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

What is a dynamic performance view in oracle?

1059

What are the major difference between truncate and delete?

1137

What happens to the indexes if a table is recovered?

1046

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1227

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2042

What is the parameter mode that can be passed to a procedure?

1111

What are triggers in oracle?

1099

How to name query output columns in oracle?

1244

What is the difference between a hot backup and a cold backup in oracle?

1079

What is a named program unit?

1138

Explain oracle instance.

1234

How to define a data field as not null?

1163

What do you understand by database schema and what does it hold?

1301

What is where clause in oracle?

1076

How do I call oracle stored procedures that take no parameters?

1206