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

How to count groups returned with the group by clause in ms sql server?

1065

What is self join in sql server joins?

1062

How to create a user name in a database?

1054

What program is used to store the data source file?

962

What is the usage of sign function?

1115

What is implicit cursors?

1086

Explain external key management in sql server 2008

890

How do I install sql server?

893

What are the difference between primary key and unique key? : sql server database administration

943

is there a column to which a default can't be bound? : Sql server database administration

1015

What is the downside of using udf?

1109

What is delete query?

941

What is data compression?

1012

What is partition, how will you implement it? : sql server analysis services, ssas

1049

explain databases and sql server databases architecture? : Sql server database administration

965