select top 1 salary from(select top 3 salary from emp order by desc) a

find out the third highest salary?

Question Posted / nitin berwal

Answer Posted / nitin berwal

select top 1 salary from(select top 3 salary from emp order
by desc) a

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is tns name?

985

What is the difference between formal parameters and actual parameters?

1090

How to update a table row with a record?

1016

What is define in oracle?

1063

What is the sid in oracle?

972

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5568

Explain a synonym?

1034

Is it possible to insert comments into sql statements return in the data model editor ?

2569

What are the advantages of oracle?

1029

What is an oracle transaction?

1150

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2299

What is the difference between primary key and unique key and foreign key in oracle?

983

What are privileges and grants?

1068

Explain the types of exception?

1148

Explain enable novalidate constraint.

1091