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

Explain in brief about Microsoft SQL server?

1014

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2668

How many cores do I need for sql server 2016?

850

What are the different types of locks in the database?

874

Explain logical operators in sql server?

1035

How will you optimize a stored procedure optimization?

956

Explain differentiate between a having clause and a where clause?

854

how would you store your query in an SSRS report or a Database server?

152

How do you migrate data from mssql server to azure?

165

Explain nested stored procedure. Syntax and an example for create nested stored procedure?

884

What are data files?

984

Do you know hot add cpu in sql server 2008?

901

Does a sql server 2005 select statement require a from?

972

What is Replication?

998

How to change a login name in ms sql server?

1026