select ename,empno,sal,r from(select ename,empno,sal,dense

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

Question Posted / shareef

Answer Posted / shareef

select ename,empno,sal,r from(select ename,empno,sal,dense_rank() over(order by sal desc) r from emp) where r=3; ----by using dense_rank()

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is oracle a relational database?

871

what is reindexing?

1611

How to convert numbers to characters in oracle?

971

How to commit the current transaction in oracle?

1047

What is parameterized cursor in oracle?

1067

What are the different pseudo commands? Explain in general?

1022

Can we connect to ORACLE db using Windows Authentication?

1183

Why is oracle database so popular?

949

How to execute a stored program unit?

1005

Explain about your project and its relation to the current job position you are applying to?

945

How to get a create statement for an existing table?

908

What is a schema in oracle?

968

Explain drop constraint oracle?

991

is there a tool to trace queries, like profiler for sql server?

1078

What does sharding mean?

946