select max(sal) from emp where sal<(select max(sal) from emp);

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

Question Posted / venkat

Answer Posted / venkat

select max(sal) from emp where sal<(select max(sal) from
emp);

Is This Answer Correct ?

19 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What is sql integrity?

1165

Is sql developer case sensitive?

1005

What is the purpose of a secondary key?

979

what are the t string functions available in tsql? : Transact sql

1013

What are all different types of collation sensitivity?

1036

What are the different types of joins in sql?

1804

What is the execution plan in sql?

1033

What is data type in database?

1001

describe mysql connection using mysql binary. : Sql dba

1072

Can we have two clustered index on a table?

1026

What are the advantages of sql? Explain

1108

Can a key be both primary and foreign?

1002

What do you mean by stored procedures?

1017

What is relationship? How many types of relationship are there?

1188

What are the different types of dbms?

1016