SELECT TOP 1 Marks (SELECT TOP 2 Marks from Tablename Order by Marks Desc

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

Question Posted / dharmendra k. dixit

Answer Posted / dharmendra k. dixit

SELECT TOP 1 Marks (SELECT TOP 2 Marks from Tablename Order
by Marks Desc)From Tablename order by Marks Asc

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How do I delete a sql server database?

1041

What is a non equi join?

979

Can you explain the disadvantages/limitation of the cursor?

987

Is there any difference between the primary key and unique key?

999

What are the different types of Indexes available in SQL Server?

1007

What are the types of subscriptions in SQL Server replication?

1031

What is a cube? : sql server analysis services, ssas

995

Do you know what is difference between index seek vs. Index scan?

954

How to create database with physical files specified in ms sql server?

991

Tell me about joins in database system and explain each in detail.

1044

What is resource db in sql server?

1020

Why should one not prefix user stored procedures with ‘sp_’?

1044

How to use clusters?

944

what is the information that can be stored inside a bit column? : Sql server database administration

961

List out what other servers you can use with ssrs?

139