OraFAQ Forum: SQL & PL/SQL » SQL queries . find second largest salary of emp.

Home » SQL & PL/SQL » SQL & PL/SQL » SQL queries . find second largest salary of emp.

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

SQL queries . find second largest salary of emp. [message #12463]

Fri, 21 May 2004 11:14

prashant
Messages: 122
Registered: September 2000

Senior Member

find a employ & it's salary having second largest salary from table having it's name ,salary &other info.

Report message to a moderator

Re: SQL queries . find second largest salary of emp. [message #12465 is a reply to message #12463]

Fri, 21 May 2004 11:36

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

Finding second highest salary

Report message to a moderator

Re: SQL queries . find second largest salary of emp. [message #12493 is a reply to message #12463]

Sun, 23 May 2004 22:01

srinu
Messages: 4
Registered: April 2002

Junior Member

hi
select * from emp a where 1=(select count(distinct
sal) from emp b);

Report message to a moderator

Re: SQL queries . find second largest salary of emp. [message #12892 is a reply to message #12465]

Wed, 09 June 2004 22:55

santosh kumar singh
Messages: 1
Registered: June 2004

Junior Member

select max(salary) from employee where salary < (select max(salary) from employee)

Report message to a moderator

Re: SQL queries . find second largest salary of emp. [message #215902 is a reply to message #12463]

Wed, 24 January 2007 04:28

v.prasad85
Messages: 1
Registered: November 2006
Location: Hyderabad

Junior Member

HI Friend,

Here i am giving my answer for ur query. Please find this.

select * from emp where
sal = (select max(sal) from emp where
sal < (select max(sal) from emp))

According to my view It is obsolutely correct.

Report message to a moderator

Re: SQL queries . find second largest salary of emp. [message #215903 is a reply to message #215902]

Wed, 24 January 2007 04:31

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Why don't we let this old thread rest? Wink

MHE

Report message to a moderator

Previous Topic:	how delete last 10 records from the table
Next Topic:	An index with no referances to actual rows

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 14:05:04 CST 2024