SELECT employee_id, first_name, last_name FROM employees ORDER BY first_name;
SELECT employee_id, first_name, last_name FROM employees ORDER BY first_name LIMIT 5;
SELECT employee_id, first_name, last_name FROM employees ORDER BY first_name LIMIT 5 OFFSET 3;
SELECT employee_id, first_name, last_name FROM employees ORDER BY first_name LIMIT 3, 5;
SELECT employee_id, first_name, last_name, salary FROM employees ORDER BY salary DESC LIMIT 5;
SELECT employee_id, first_name, last_name, salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;
SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1, 1;
SELECT employee_id, first_name, last_name, salary FROM employees WHERE salary = 17000;
SELECT employee_id, first_name, last_name, salary FROM employees WHERE salary = ( SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1, 1 );