SELECT MIN(SAL) FROM (SELECT DISTINCT * FROM EMP ORDER BY DESC) WHERE ROWNU

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

Question Posted / anita prasad

Answer Posted / anita prasad

SELECT MIN(SAL) FROM (SELECT DISTINCT * FROM EMP ORDER BY DESC) WHERE ROWNUM<3;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to use transactions efficiently : transact sql

1062

How is a process of pl/sql compiled?

1167

How to test for null values?

1057

Is primary key clustered index?

954

How many sql statements are used?

1018

What are character functions in sql?

943

Can we call a function containing dml statements in a select query?

988

How to run sql*plus commands in sql developer?

1163

What is a clob in sql?

1026

Mention what is the plv (pl/vision) package offers?

1108

Which is better join or inner query?

1061

How do I remove all records from a table?

1081

Explain exception handling in pl/sql?

1042

Mention what does plv msg allows you to do?

1127

What is the difference between drop and truncate commands?

1063