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

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

1093

How do I port a number to sql server?

1032

what information is maintained within the msdb database? : Sql server administration

968

Is sql server free?

913

What are system databases in ms sql server?

1049

How to insert multiple rows with one insert statement in ms sql server?

1115

what purpose does the model database serve? : Sql server database administration

971

what is database replication? : Sql server database administration

1056

Explain database normalization?

1214

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

1181

What is trace flag in sql server?

1016

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

955

What is cursors?

1173

What are diverse clauses that form a part of sql?

1065

What is transactional replication?

958