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 / m

Answer Posted / m

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

Is This Answer Correct ?

222 Yes

39 No

Please Help Members By Posting Answers For Below Questions

Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.

1008

How do I truncate a sql log file?

1072

What is constant in pl sql?

1021

what is 'mysqldump'? : Sql dba

1108

What are tables in sql?

1061

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

997

What is having clause in sql?

963

What is the difference between rename and alias?

1341

Does sap use sql?

990

How to select all records from the table?

1135

Which table is left in left join?

1012

What is the command used to fetch first 5 characters of the string?

1398

what is the difference between undefined value and null value? : Sql dba

1101

What is a trigger in sql?

1200

How does sql store data?

910