select distinct (a.sal) from emp a where &n = (select count (distinct(

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

Question Posted / reddy

Answer Posted / reddy

select distinct (a.sal) from emp a where &n = (select count
(distinct(b.sal) from emp bmwhere a.sal<=b.sal)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is the difference difference between procedure and packages

10410

What is the difference between sql and isql*plus?

1097

Is delete faster than truncate?

1002

What is the difference between a procedure and a function?

1113

Is sql a programming?

978

what is the difference between delete and truncate statement in sql? : Sql dba

1247

How do I make sql search faster?

998

Which tcp/ip port does sql server run?

1009

What is oracle and pl sql?

1119

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

1000

How do I trace sql profiler?

985

what is data integrity? : Sql dba

1038

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

2170

When you have to use a default "rollback to" savepoint of plvlog?

1197

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1224