select top 1 marks from (select top 2 distinct marks from students order

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

Question Posted / abhishek srivastava

Answer Posted / abhishek srivastava

select top 1 marks from (select top 2 distinct marks from
students order by marks desc)
order by marks

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

1104

How real and float literal values are rounded?

1200

What is DCL?

1103

Write a SQL query in order to merge two different columns into single column?

1086

Do you know what are various aggregate functions that are available?

1215

Write a SQL query to make a column as unique?

1078

What is the maximum number of index per table?

1117

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

1017

What kind of problems occurs if we do not implement proper locking strategy?

1461

How many replicas are maintained for each SQL Azure database?

144

What is report server project?

155

What are sparse columns?

1065

What are the requirements on sql server network connections?

1041

Describe how to use linked server?

1077

Why SQL Agent is used?

1204