Subqueries [message #528] |
Mon, 18 February 2002 10:20 |
Tony
Messages: 190 Registered: June 2001
|
Senior Member |
|
|
Can someone explain this query and the results for me please? I was expecting to get only KING 5000 back... why am I getting back all those records?
Thanks!
Tony
scott@REALM1> select e.ename, e.sal
2 from emp e
3 where e.sal =
4 (select max(e.sal)
5 from emp);
ENAME SAL
---------- ----------
SMITH 800
ALLEN 1600
WARD 1250
JONES 2975
MARTIN 1250
BLAKE 2850
CLARK 2450
SCOTT 3000
KING 5000
TURNER 1500
ADAMS 1100
ENAME SAL
---------- ----------
JAMES 950
FORD 3000
MILLER 1300
|
|
|
|
|
My Bad! [message #541 is a reply to message #528] |
Tue, 19 February 2002 04:06 |
Tony
Messages: 190 Registered: June 2001
|
Senior Member |
|
|
What an idiot I am... I should have known that. I stared at it for like 30 minutes! :)
Thanks!
Tony
|
|
|