SELECT * FROM( SELECT ROW_NUMBER() OVER (ORDER BY mark) AS Stu

I have student marks in a student table. I need second
highest mark .Then what will the query for this?

Question Posted / sagesh

Answer Posted / sagesh

SELECT * FROM(
SELECT ROW_NUMBER() OVER (ORDER BY mark) AS Stu_Rank
FROM student) As T
WHERE Stu_Rank = 2

Is This Answer Correct ?

2 Yes

5 No

Please Help Members By Posting Answers For Below Questions

Define outer join?

748

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

749

What are logical/boolean operations in ms sql server?

718

Tell me what is the difference between locking and multi-versioning?

757

What is bcnf normalization form?

847

What do you mean by subquery?

746

How to rebuild master databse?

834

What is the difference between drop table and truncate table?

655

What is tablesample?

764

Can You Use A Stored Procedure To Provide Data To An Ssrs Report?

129

Explain atomicity?

727

How can you ensure that the database and sql server based application perform well?

793

What is SQL Azure Firewall?

128

What is the use of builtinadministrators group in sql server? : sql server security

716

How to backup SQL Server Reporting Services ?

122