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

How does postgresql compare to "nosql"?

998

What is a sql instance vs database?

1058

What are the 3 modes of parameter?

1119

what is the difference between group by and order by in sql? : Sql dba

1078

Which join condition can be specified using on clause?

914

How do you pronounce sql?

969

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

973

what is a composite primary key ? : Sql dba

1013

Is and as keyword in pl sql?

923

what are the advantages of using stored procedures? : Sql dba

1076

What is the difference between inner join and outer join?

949

Explain architecture of sql server notification services?

1008

What is spool?

1008

What is the use of function in sql?

1044

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1169