select * from(select e.*,row_number() over (order by e.salary desc)rn from

how to find the second highest salary from emp table?

Question Posted / vikas

Answer Posted / vikas

select * from(select e.*,row_number() over (order by
e.salary desc)rn from Employee e)where rn between 1 and 2
order by rn

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the benefits of stored procedures?

1075

What are the popular database management systems in the it industry?

1003

when MSQL8.0 is in market

2082

What are the qualities of 2nf?

1040

What are the types of variable use in pl sql?

1087

How is indexing done in search engines?

982

define join and explain different type of joins? : Sql dba

955

What is a table in a database?

1051

what are date and time data types in mysql? : Sql dba

977

Compare sql & pl/sql

1144

What is a parameter query?

1091

Is pl sql and postgresql same?

1139

What are sql data types?

1034

Why coalesce is used in sql?

1016

What are secondary keys?

976