Displaying names using conditions

Question

I would like to know if I have a certain table, let's say table X which contains salary and names, how would I display the maximum salary along with corresponding names? Thank you.

you will have to create it by yourself. – SMA Nov 10 '14 at 08:28 — SMA, Nov 10 '14 at 08:28

score 1 · Answer 1 · answered Nov 10 '14 at 08:28

1

select salary, name
from X
where salary = (select MAX(salary) from X)

answered Nov 10 '14 at 08:28

Stijn Geukens

15,149
7
65
100

score 0 · Answer 2 · answered Nov 10 '14 at 08:35

Let's see this using EMP table example :

SQL> WITH DATA AS(
  2  SELECT MAX(sal) max_sal FROM emp)
  3  SELECT ename, sal
  4  FROM emp
  5  WHERE sal = (SELECT max_sal FROM DATA)
  6  /

ENAME             SAL
---------- ----------
KING             5000

SQL>

Displaying names using conditions

2 Answers2