select q.sal from emp q where 3=(select distinct(count(b.sal))

Find out the 3rd highest salary?

Question Posted / srikanth

Answer Posted / srikanth

select q.sal
from emp q
where 3=(select distinct(count(b.sal))
from emp b
where q.sal<=b.sal)

Is This Answer Correct ?

17 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Explain what is dbms?

990

What is auto increment feature in sql?

1068

What are triggers in sql?

974

What are the types of functions in sql?

968

How exception handling is done in advance pl/sql?

920

What is structural independence and why is it important?

979

What is lookup table in sql?

982

What are inner and outer joins examples of both?

881

how to convert dates to character strings? : Sql dba

1073

Is stored procedure faster than query?

916

How sql query is executed?

1069

What is the difference between cross join and natural join?

962

Why is nosql good?

977

How to create a menu in sqlplus or pl/sql?

1065

What is range partitioning?

913