EasyBasic SELECT
Select top 10 highest paid employees
The query
SQL
SELECT first_name, last_name, salary
FROM employees
ORDER BY salary DESC
LIMIT 10;Note
“LIMIT restricts the number of rows returned. ORDER BY DESC sorts highest first.
SELECT first_name, last_name, salary
FROM employees
ORDER BY salary DESC
LIMIT 10;Note
“LIMIT restricts the number of rows returned. ORDER BY DESC sorts highest first.