select top 1 * from (select top 2 * from emp order by sal desc)s order by

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

Question Posted / naresh kumar kalangi

Answer Posted / naresh kumar kalangi

select top 1 * from (select top 2 * from emp order by sal
desc)s order by sal

Is This Answer Correct ?

5 Yes

8 No

Please Help Members By Posting Answers For Below Questions

What are basic techniques of indexing?

1325

What plvcmt and plvrb does in pl/sql?

1251

What type of database is cloud sql?

1046

How to rename a column in the output of sql query?

1005

What is a unique key?

1006

explain advantages of innodb over myisam. : Sql dba

1085

what is a tablespace? : Sql dba

1007

How does postgresql compare to oracle/db2/ms sql server/informix?

983

What is a constraint?

963

Is primary key always clustered index?

948

What are the types of variable use in pl sql?

1012

what is try_catch block in procedure

1659

What is the difference between clustered and non-clustered index in sql?

959

How can you fetch first 5 characters of the string?

948

how many sql ddl commands are supported by 'mysql'? : Sql dba

959