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

In pl/sql, what is bulk binding, and when/how would it help performance?

1030

What is a database event trigger?

1209

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1169

Which is better join or inner query?

1120

Mention what plvcmt and plvrb does in pl/sql?

1196

How many triggers can be applied to a table?

1122

What are local and global variables and their differences?

1134

Can we insert data into view?

948

What is rtm stands for?

1171

Name the operator which is used in the query for pattern matching?

1001

What are the two characteristics of a primary key?

1029

What is vector point function?

1094

What is sql query optimization?

1188

How is use pl and sql?

1105

What is procedure function?

1121