Home » SQL & PL/SQL » SQL & PL/SQL » Explain The Query
Explain The Query [message #1193] Wed, 10 April 2002 08:23 Go to next message
Arish Zishan
Messages: 3
Registered: April 2002
Junior Member
Can someone explain how the following query works to return Top 3 salaries

select ename,job,sal from emp a
where 3>=(select count(distinct sal) from emp b
where b.sal>=a.sal)
order by sal desc ;

Report message to a moderator

Re: Explain The Query [message #1205 is a reply to message #1193] Thu, 11 April 2002 02:22 Go to previous message
devx
Messages: 1
Registered: April 2002
Junior Member
you should try to use SELECT * TOP 3 FROM ..., which is easier!

Report message to a moderator

Previous Topic: Import database from Oracle to SQL? Help!
Next Topic: Database procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 19:28:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.