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

Find out the 3rd highest salary?

Question Posted / a.jyothsna

Answer Posted / a.jyothsna

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

Is This Answer Correct ?

100 Yes

45 No

Please Help Members By Posting Answers For Below Questions

Write a sql query to find the names of employees that begin with ‘a’?

991

Does truncate require commit?

955

Can I call a procedure inside a function?

986

Why do we need cursor in pl sql?

1121

How does sql store data?

891

How do you optimize a stored procedure query?

983

How does sql developer connect to oracle database?

984

What is synonyms?

1040

What type of join is sql join?

963

What is meant by <> in sql?

940

How to know the last executed procedure?

1071

Which sql most popular?

975

Is ms sql traffic encrypted?

909

What is a database? Explain

1096

What is an index in sql with example?

959