select min(sal) from (select top 3 salary from employee);

Find out the 3rd highest salary?

Question Posted / sathiskumar

Answer Posted / sathiskumar

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is bind reference and how can it be created?

1021

What are sql triggers used for?

998

What is a natural join?

1075

What is sql table?

976

What are different types of queries in sql?

1121

How do I run a sql script?

1153

How do you delete a table?

1082

How to get list of all tables from a database?

1161

What is sql profiling in oracle?

1066

What is query syntax?

978

What is raw datatype in sql?

1048

How many joins can you have in sql?

939

What is the difference between instead of trigger and after trigger?

1013

How do you write a subquery?

1032

What are the methods of filing?

935