Find Most Frequent Salary In Employees

Find the salary that occurs most frequently.

sql

SELECT salary FROM employees GROUP BY salary ORDER BY COUNT(salary) DESC LIMIT 1;

This query groups the records by the "salary" column, counts the occurrences of each, sorts them in descending order, and returns the salary with the highest frequency.

PromptDB can make mistakes. Please double-check responses.