select * from emp a where &n=(select count(distinct (sal)) from emp f

how to get second highest salary in SQL(as/4000

Question Posted / c srirammulu

Answer Posted / c srirammulu

select * from emp a where &n=(select count(distinct (sal))
from emp f where a.sal<f.sal)

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

is it possible to pass an object or table to a procedure as an argument?

1127

Why we use stored procedure instead of query?

997

Why schema is used in sql?

1047

What is replication id?

933

what is a trigger? : Sql dba

1024

what is foreign key? : Sql dba

1026

What is the difference between numeric and autonumber?

994

How do you use collections in procedure to return the resultset?

2236

What is difference between primary and secondary key?

1022

how to get a list of indexes of an existing table? : Sql dba

955

How do you write an inner join query?

946

What is rename command in sql?

1030

Is sql workbench free?

990

What is sql indexing?

1008

How do we use distinct statement? What is its use?

1028