This will give you third highest salary select ename, sal from (Select

Find out the 3rd highest salary?

Question Posted / srijith pillai

Answer Posted / srijith pillai

This will give you third highest salary

select ename, sal from
(Select name, sal, rownum()Over(Order by sal Desc) rt
FROM emp)
where rt = 3;

Is This Answer Correct ?

13 Yes

19 No

Please Help Members By Posting Answers For Below Questions

Cite the differences between execution of triggers and stored procedures?

1057

What is sqlerrd?

938

What is a column in a table?

1086

What is the use of index in hive?

983

What is case function?

1004

How does postgresql compare to oracle/db2/ms sql server/informix?

1000

Can we insert delete data in view?

914

What is the use of primary key?

974

Can two tables have same primary key?

934

What is $$ in sql?

961

What is Materialized View? In What Scenario we Use Materialized View?

9451

Why is nosql good?

993

Explain spool.

1132

how to convert numeric values to character strings? : Sql dba

1059

What are pl/sql packages?

1063