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

Why variables called the most powerful component of ssis?

1082

What will happen if a column containing char type data is changed to the nchar data type?

1103

Difference between connected and disconnected database in .net with sql server?

1097

What is trigger explain with program?

983

How to invoke a trigger on demand?

1092

What is the use of “join” in sql server?

1095

How to convert a numeric expression from one data type to another?

1016

Determine when an index is appropriate?

1078

What is the use of set nocount on/off statement?

1097

How can we migrate from SQL server to SQL Azure?

113

Explain about thread and memory management process of SQL?

973

How to create prepared statements using odbc_prepare()?

1065

What is data mart? : sql server analysis services, ssas

1055

What is difference in performance between insert top (n) into table and using top with insert?

1046

What are the advantages of paper records?

969