select * from emp where sal=(select a.sal from emp awhere 3=(select distinc

Find out the 3rd highest salary?

Question Posted / shibin k abraham

Answer Posted / shibin k abraham

select * from emp where sal=(select a.sal from emp awhere 3=(select distinct(count(b.sal)) from emp b where a.sal<=b.sal))

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the 3 types of behavioral triggers?

1181

Write a sql select query that only returns each name only once from a table?

958

What is query optimization in sql?

934

Is sqlite free?

907

what is uncommittable transactions? : Transact sql

952

What are inner and outer joins examples of both?

878

What plvcmt and plvrb does in pl/sql?

1249

how are mysql timestamps seen to a user? : Sql dba

1047

Are subqueries faster than joins?

948

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2527

Explain autonomous transaction.

1092

Why are aggregate functions called so?

896

What are the different dcl commands in sql?

1063

Why do we use sql constraints? Which constraints we can use while creating database in sql?

971

When is the explicit cursor used ?

976