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

What is the meaning of resultset type_scroll_insensitive?

992

What is the difference between getdate and sysdatetime?

1061

Tell me what is log shipping?

1032

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

What is the bookmark lookup and rid lookup?

1034

How to create an index on a view?

1139

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1101

What do you understand by triggers?

977

Is sql server is free?

1017

What is a select query statement in ms sql server?

1130

How can I check if a view exists in a sql server database?

1081

How do I find my localdb version?

1028

What happens if we shrink log file in sql server?

1031

Define tool Manage Statistics in SQL Server 2000 query ?

1166

What is coalesce in sql server?

1102