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
64176 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

In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??

1591

What privilege is needed for a user to create indexes in oracle?

965

What are a query and state the different types of queries and their uses?

942

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1058

What is a package ? What are the advantages of package ?

1033

Will you be able to store pictures in the database?

1063

What is a private synonym?

1531

How to delete a user account in oracle?

915

How to write a left outer join with the where clause in oracle?

1027

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

1042

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2130

types of indexes and the rationale behind choosing a particular index for a situation.

2445

How to lock and unlock a user account in oracle?

1028

What are the original export and import utilities?

1058

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

2294