1Who is the person getting 1st max salary
2SELECT first-name
3FROM employees
4WHERE salary = (SELECT MAX(salary) FROM employees);
5
62nd max salary=
7SELECT first-name , salary
8FROM employees
9WHERE salary = (SELECT MAX(salary) FROM employees WHERE salary NOT IN
10(SELECT MAX(salary) FROM employees));
11
123rd max salary=
13SELECT * FROM employees
14WHERE salary = (SELECT * FROM (SELECT DISTINCT salary FROM employees
15ORDER BY salary DESC) WHERE ROW NUM <=3
16MINUS
17SELECT * FROM (SELECT DISTINCT salary FROM employees
18ORDER BY salary DESC) WHERE ROW NUM <=2);