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 is full form of rtm?

1008

How many databases can sql express handle?

987

Why do we use procedures?

960

What is an emotional trigger?

1005

What is compute?

1091

How do I remove all records from a table?

1075

What does select * from mean in sql?

3240

Which is the correct statement about truncate and delete?

1112

What does pragma mean?

1056

what is heap table? : Sql dba

1106

How many types of normalization are there?

966

What is %rowtype in pl sql?

991

Is left join same as inner join?

1131

List and explain the different types of join clauses supported in ansi-standard sql?

1356

Is mariadb nosql?

1041