OraFAQ Forum: SQL & PL/SQL » Subqueries

Home » SQL & PL/SQL » SQL & PL/SQL » Subqueries

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Subqueries [message #530 is a reply to message #528]

Mon, 18 February 2002 14:34

HOW TO GET CONTEXT OF AN
Messages: 6
Registered: February 2002

Junior Member

there is no alias 'e' before the 'sale' in :'select
max(e.sale) from emp ', or the subquery returns a
value equal to the e.sale .

Report message to a moderator

Re: Subqueries [message #537 is a reply to message #528]

Mon, 18 February 2002 21:29

NAVODAYA
Messages: 4
Registered: February 2002

Junior Member

select e.ename,e.sal from emp e where e.sal=(select max(e.sal) from emp e)

Report message to a moderator

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

Report message to a moderator

Previous Topic:	sql
Next Topic:	Outer Joins

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 07:50:15 CDT 2024