Home » RDBMS Server » Server Administration » Re: SQL QUERY
Re: SQL QUERY [message #373534] Sun, 22 April 2001 03:52
Venkat
Messages: 110
Registered: February 2001
Senior Member
please try this query, give Whatever u want that is 1st max. salary, or 2nd max. salary like ..

select * from emp x where &n =(select count(distinct(sal)) from emp y where x.sal <= y.sal)

then let me know i got the answer or not

Report message to a moderator

Previous Topic: New jobs section - please post resumes and projects
Next Topic: phone format
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:34:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.