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

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2046

How can I see all tables in oracle?

951

What is procedure overloading in oracle?

994

What happens if variable names collide with table/column names?

1105

What is the implicit cursor in oracle?

1039

ABOUT IDENTITY?

2006

What are the varoius components of physical database structure of oracle database?

946

How to convert dates to characters in oracle?

987

Is rowid unique in oracle?

939

Difference between varchar and varchar2 data types?

1118

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2295

How to connect asp pages to oracle servers?

1007

How to do paging with oracle?

950

How to turn on or off recycle bin for the instance?

1012

What is BBED in Oracle?

1091