Select Top 1 sal from (select distinct top 3 sal from emp order by sal des

find out the third highest salary?

Question Posted / abhay

Answer Posted / abhay

Select Top 1 sal from (select distinct top 3 sal from emp
order by sal desc)a order by sal

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain what are the type of synonyms?

1109

What is a user role in oracle?

1121

What is integrity and what is constraint??Explain with example

2280

Can you drop an index associated with a unique or primary key constraint?

1019

What is oracle instant client?

1024

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1043

Use of an integrity constraint is better to validate data. Explain

1040

Explain what are the uses of rollback segment?

1004

What are the most common interview questions on ETL Testing for experience?

1142

State the various uses of dbcc command?

1058

What the is the diff between local index and global index. give some example.

1638

What is a trigger oracle?

1082

What is the quickest way to export a table to a flat file?

966

How to assign a tablespace to a users in oracle?

1048

What is null value in oracle?

1097