select sal from emp a where 1=(select count(*) from emp b where a.sal>b.

how to find the second highest salary from emp table?

Question Posted / prudhvi

211 Answers
361353 Views
CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
E-Mail Answers

Answer Posted / prudhvi

select sal from emp a where 1=(select count(*) from emp b where a.sal>b.sal);

Try this guys,if u want highest sal use 0 in where condition, for second highest 1,third 2........

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the limitations of sql express?

988

Why is sql important?

1026

What are hotfixes and patches?

889

How do I run sql?

1096

what is 'mysqld'? : Sql dba

909

What are the different types of a subquery?

983

what is the command line end user interface - mysql? : Sql dba

925

Is sql a oracle?

916

What does the base_object_type column shows in the user.triggers data dictionary view?

1000

Is pl sql and postgresql same?

1058

Explain the update statement in sql

918

What is sqlca in powerbuilder?

956

How many postgresql users are there, worldwide?

994

What are the types of keys?

935

How does sql developer connect to oracle database?

950