0Topic: SQL
ORDER BY&LIMITfor Business InsightsThis lesson demonstrates how to extract the top 5 highest-paid employees using simple SQL techniques.
Use Case:
In many HR analytics reports, identifying top earners helps in reviewing compensation structures and promotions.SQL Query:
SELECT Name, Salary FROM hr_employees ORDER BY Salary DESC LIMIT 5;Output Example:
Name Salary Shari Gonzales 118523 Hayden Spencer 117541 Tyrone Davis 117404 Dr. Angela Benitez 116961 Autumn Blackburn 115213 Insight:
This query helps identify the top 5 highest earners in the organization — useful for HR review meetings and payroll audits.
