Search⌘ K

Question: Aggregate Records Using MIN/MAX

Explore how to use SQL aggregate functions MIN and MAX to identify specific salary values from an employee table. This lesson helps you understand and write queries that find the second highest salary, enhancing your practical SQL skills for interviews and real-world database tasks.

Question

Given the following Employees table structure:

Employees

EmpID

EmpName

Salary

1

Susan Lee

50000.00

2

Alexa Smith

60000.00

3

Dana Amberson

45000.00

4

Sarah Ronald

47000.00

Additional information

You are provided with a table named Employees that contains ...