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

what is uncommittable transactions? : Transact sql

565

What is the process of copying data from table a to table b?

596

How do I restart sql?

524

what is meant by nl2br()? : Sql dba

564

When is the explicit cursor used ?

588

What is insert command in sql?

526

What are analytic functions in sql?

547

Is sql a oracle?

521

How can triggers be used for the table auditing?

592

What is auto increment in sql?

583

what is dbms? : Sql dba

541

Why commit is not used in triggers?

576

What is sap sql anywhere?

531

Is sql database free?

525

What is dml and ddl?

521