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

What is sql character function?

1097

Explain clause in sql?

1036

How are functions and procedures called in PL/SQL?

1241

what is the difference between join and union? : Sql dba

1122

what is normalization? : Sql dba

1091

What is Histogram?

1564

What is database sql?

1059

What are user defined functions?

1024

How do you rename a table in sql?

1123

What is the use of sqldataadapter?

981

what are the disadvantages of mysql? : Sql dba

1151

Is record in pl sql?

984

What is a common use of group by in sql?

1053

What are the operators in sql?

1036

What are views in sql?

995