select id,salary from (select id,salary,ROW_NUMBER()over (order by salary d

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / tejasvita dhuri

Answer Posted / tejasvita dhuri

select id,salary from (select id,salary,ROW_NUMBER()over (order by salary desc) as rowcol from emp)A
where A.rowcol=2

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are the different sql commands?

1127

Is not null in sql?

1045

What is the difference between inner join and natural join?

1057

what does myisamchk do? : Sql dba

1079

What is the use of nvl function?

1243

Explain the difference between drop and truncate commands in sql?

1110

What is group by in sql?

1126

What are the triggers associated with image items?

1089

what is sql server agent? : Sql dba

1158

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

1051

What packages(if any) has oracle provided for use by developers?

5883

What is sql in java?

1134

When are we going to use truncate and delete?

1022

Is primary key a clustered index?

1009

Is join same as left join?

1083