select top 1 * from (select top 2 marks from student order by marks desc)a

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

Question Posted / maheswar reddy s

Answer Posted / maheswar reddy s

select top 1 * from (select top 2 marks from student order by marks desc)a order by marks

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

938

What happens if null values are involved in bitwise operations?

1078

What does asynchronous call backs means?

1225

Can you force a query to use a specific index?

989

How to drop existing indexes in ms sql server?

1130

What is SQL Azure Firewall?

136

How to end a stored procedure properly in ms sql server?

1144

How to use “drop” keyword in sql server and give an example?

1193

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

961

When a primary key constraint is included in a table, what other constraints does this imply?

1021

How use inner join in sql server?

1187

How to rename databases in ms sql server?

1259

Explain the benefits of user-defined functions?

1122

How to create a login account in ms sql server to access the database engine using "create login" statements?

1195

What are rest-style architecture's?

172