SELECT ENAME,SAL FROM (SELECT ENAME,SAL FROM EMP ORDER BY SAL DESC) WHERE

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

Question Posted / subodh tiwari

34 Answers
65567 Views
CTS, Keane India Ltd, TCS, Wipro, I also Faced
E-Mail Answers

Answer Posted / subodh tiwari

SELECT ENAME,SAL FROM (SELECT ENAME,SAL FROM EMP ORDER BY
SAL DESC) WHERE ROWNUM<=2

Is This Answer Correct ?

15 Yes

9 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to loop through data rows in the implicit cursor?

1082

How to assign a table row to a record variable?

1048

What are the different types of modules in oracle forms?

1006

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1861

What is max rowid in oracle?

1031

How to get a list of all user accounts in the database?

1090

What are group functions in oracle?

1049

What is columnar storage what is the advantage?

1070

What is blob datatype?

1134

What do you mean by cdb and pdb in oracle 12c?

1063

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2344

What are ddl statements in oracle?

1082

how to do daily transactions with out sql* loader control file regesterd in apps?

1690

How to export data to a csv file?

1313

How to see the table columns used in an index?

1025