SELECT SAL FROM (SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RANK FROM

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

Question Posted / satish

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

Answer Posted / satish

SELECT SAL FROM (SELECT SAL,DENSE_RANK() OVER(ORDER BY SAL DESC) RANK FROM EMP) WHERE RANK=2;

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what are actual and formal parameters?

1051

Explain an index segment?

1043

What is oracle data type?

903

What is oracle datasource?

926

What are the database administrators utilities available?

973

How do I call oracle stored procedures that take no parameters?

1025

How can Oracle users be audited?

1056

What is logical backup in oracle?

969

How to recover a dropped table in oracle?

984

What is a oracle database?

996

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2074

How to define an anonymous procedure without variables?

1025

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2398

What are the different types of synonyms?

1078

What is a tns service name?

945