All Tracks Problem

Employee with the highest salary
Tag(s):

Easy

Problem
Editorial
Analytics

Use the Employee table to write a query that will return the following information about the highest-paid employee

  • Employee ID
  • Salary

Sample input

Table: Employee

Field Type
EmployeeID text
FirstName text
LastName text
Salary integer
Department text
Gender text

Sample

EmployeeID FirstName LastName Salary Department Gender
1 Bob Johnson 600000 IT Male
3 Betty Davis 1000000 IT Female
4 Tara Brown 480000 HR Female
5 John Moore 500000 Payroll Male
2 Mike Jones 530000 HR Male

Sample output

EmployeeID Salary
3 1000000
Time Limit: 5 sec(s) for each input file.
Memory Limit: 256 MB
Source Limit: 1024 KB
Marking Scheme: Marks are awarded when all the testcases pass.
Allowed Languages: MySQL, PostgreSQL, MSSQL, Oracle Database

CODE EDITOR

Initializing Code Editor...
Your Rating:
Notifications
View All Notifications