THis is for Oracle SELECT * FROM emp (SELECT empname,Salary,dense

find out the third highest salary?

Question Posted / dilip tiwari

Answer Posted / dilip tiwari

THis is for Oracle

SELECT * FROM emp
(SELECT empname,Salary,dense_rank() OVER(ORDER BY salary
DESC) AS ranking FROM emp)
WHERE ranking = 3

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to define a data source name (dsn) in odbc manager?

1026

What is an oracle wallet?

942

How do I connect to oracle database?

1112

Can we connect to ORACLE db using Windows Authentication?

1249

What is a read write transaction in oracle?

1086

How do I know if oracle is installed on windows?

929

How to connect ms access to oracle servers?

1003

How to convert character types to numeric types?

1124

Give syntax for SQL and ORACLE joins.

1092

What is the usage of analyze command in oracle?

1093

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1047

State any two functions of oracle?

1044

Explain the use of inctype option in exp command.

1030

What is the oracle implicit cursor?

1058

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1346