select * from (select *,rowcount()over (orderby emp desc)as rank from emp

how to find the second highest salary from emp table?

Question Posted / lakshmi

Answer Posted / lakshmi

select * from (select *,rowcount()over (orderby emp desc)as
rank from emp)b where rank=2

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can we rollback after truncate?

1034

What is the use of pl/sql table?

1068

Is clustered index a primary key?

950

What is pl sql in dbms?

954

What is a table partition?

1137

how to shut down the server with 'mysqladmin'? : Sql dba

1014

what is a composite primary key ? : Sql dba

1055

Does truncate remove indexes?

1038

how to drop an existing table in mysql? : Sql dba

1048

What is lookup table in sql?

1053

What is meant by user defined function?

1054

what are all the different normalizations? : Sql dba

1047

Explain autonomous transaction.

1161

What type of join is sql join?

987

What is prepared statement in sql?

1056