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

What is oracle host variable?

1129

What is varray?

1192

How to connect to the server with user account: sys?

1059

What are a collation and state the different types of collation sensitivity?

1233

material view and view disadvantages?

1122

Can select statements be used on views in oracle?

1082

Define oracle database

1091

Explain what are the uses of rollback segment?

1064

What are the oracle differences between nvl and coalesce

1233

What is java oracle used for?

1075

Explain a synonym?

1086

What is a cursor and what are the steps need to be taken?

1283

Explain the dml?

1041

What is transaction control statement and how many types of transaction control statement in Oracle?

1229

How to create additional tablespaces for an new database?

1075