select * from emp where 2(select count(distinct sal) from emp e where sal&

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / prasanna

Answer Posted / prasanna

select * from emp where 2(select count(distinct sal) from
emp e where sal>=e.sal);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How do I kill a query in postgresql?

1014

Can we commit inside a trigger?

945

What are the datatypes available in pl/sql ?

1045

what are date and time intervals? : Sql dba

998

how many ways to get the current time? : Sql dba

950

Does oracle roll back the transaction on an error?

962

What is nested table in pl sql?

1007

Why do we use procedures?

914

what are all the common sql function? : Sql dba

1013

what is data manipulation language? : Sql dba

949

Explain ddl statements in pl/sql?

961

what are the advantages a stored procedure? : Sql dba

926

Write an sql query to select all records from the table?

970

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1037

what is the difference between a web-garden and a web-farm? : Sql dba

1012