All Tracks Problem

Employee with the lowest salary
Tag(s):

Muito fácil, Very-Easy, とてもやさしい, 非常に簡単

Problem
Editorial
Analytics

Use the Employee table to write a query that will return the following information about the least 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
4 480000
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_Db

CODE EDITOR

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