...

/

Question: Aggregate Records Using MIN/MAX

Question: Aggregate Records Using MIN/MAX

Learn how to find the second-highest number in a table using an SQL query.

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

...