Home » RDBMS Server » Server Administration » Query not solved
Query not solved [message #374623] Thu, 21 June 2001 15:27 Go to next message
j_satya
Messages: 5
Registered: June 2001
Location: India
Junior Member
I want top 5 enames from emp tables.ie top 5 salaries persons.
exp.
KING 5000
scott 3000
ford 3000
xyz 2500
sss 2000
regards
satya.

Report message to a moderator

solution to your problem [message #374662 is a reply to message #374623] Fri, 22 June 2001 23:49 Go to previous message
debasish
Messages: 14
Registered: January 2001
Junior Member
select * from
(select ename,sal from emp order by sal desc)
where rownum<6

Report message to a moderator

Previous Topic: Re: SQL view.
Next Topic: How to extract month component from the DATE in oracle?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 18:37:18 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.