select rownum,salary from(select rownum r,salary from emp order by salary)w

find out the third highest salary?

Question Posted / rajeevgeu

Answer Posted / rajeevgeu

select rownum,salary from(select rownum r,salary from emp order by salary)where r=3;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is meant by joins?

1110

What is difference between sid and service name in oracle?

1018

What are the ansi data types supported in oracle?

992

Explain an index?

1182

What is bulk collect in oracle?

1054

How to add another datafile to a tablespace?

1091

How to delete an existing row from a table in oracle?

1130

How to execute a stored procedure in oracle?

1148

What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?

1166

What is data type in oracle?

1185

How do you bind variables in oracle?

1024

what are the default admin accounts in Oracle 10g ?

1024

What is an oracle?

1069

What are the different oracle database objects?

1150

Explain an extent?

1158