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

What is mdb stand for?

1005

What is the difference between clustered and non-clustered index in sql?

1013

What is recursive join in sql?

1004

What is bitemporal narrowing?

1305

What is the function that is used to transfer a pl/sql table log to a database table?

1010

What is $$ in sql?

990

Are stored procedures faster than dynamic sql?

1031

What is microsoft t sql?

942

How to return multiple rows from the stored procedure?

968

What's the procedure?

925

What is rowtype?

1017

what are the maximum number of rows that can be constructed by inserting rows directly in value list? : Transact sql

949

What is the difference between execution of triggers and stored procedures?

1115

What is application trigger?

994

What is a behavioral trigger?

972