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 nvl?

1116

Which operator is used in query for pattern matching?

1133

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1133

What is the difference between joins?

1094

what tools available for managing mysql server? : Sql dba

1132

what is foreign key? : Sql dba

1110

What are the operators used in select statements?

1100

what is sql in mysql? : Sql dba

1238

what is a trigger in mysql? : Sql dba

1216

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

1094

What do you think about pl/sql?

1126

what are sequences

1824

How much does sql cost?

1067

Is grant a ddl statement?

945

how to use like conditions? : Sql dba

1166