SELECT sal FROM(SELECT DISTINCT(sal) FROM employees ORDER BY sal DESC) WH

Query to get max and second max in oracle in one query ?

Question Posted / samir kumar sahoo

Answer Posted / samir kumar sahoo

SELECT sal FROM(SELECT DISTINCT(sal) FROM employees ORDER
BY sal DESC) WHERE ROWNUM<=2;

Is This Answer Correct ?

23 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to insert multiple rows with one insert statement in oracle?

1022

Explain the use of online redo log files in oracle.

993

What is oracle used for?

971

What is columnar storage what is the advantage?

985

When do you get a .pll extension in oracle?

1078

What is a connect identifier?

983

How does the on-delete-cascade statement work?

1061

How to delete an existing row from a table in oracle?

1019

Whether any commands are used for months calculation? If so, what are they?

1042

How can windows applications connect to oracle servers?

986

How to export your own schema?

971

What is a proxy class?

969

Explain table?

1061

What are the different types of record groups in oracle? Explain each of them

972

How to connect to a remote server?

1054