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.
We'll cover the following...
We'll cover the following...
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 ...