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

How do I count duplicates in sql?

1033

what is the bond code in materialized view?

2933

What do you mean by stored procedures? How do we use it?

931

what are the types of join and explain each? : Sql dba

991

What is the difference between the implicit and explicit cursors?

994

What is sql comments?

1038

which operator is used in query for pattern matching? : Sql dba

949

What if we write return in procedure?

1336

What does the argument [or replace] do?

1017

What is package in pl sql with an examples?

972

How do you use collections in procedure to return the resultset?

2184

What is consistency?

1062

What are different types of sql?

1100

How do you declare a constant?

911

Does a user_objects view have an entry for a trigger?

963