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 I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio

976

How fixed length strings are truncated and padded?

975

What are the advantages of using stored procedures?

944

What is a filestream?

988

How to get a list of columns using the "sys.columns" view in ms sql server?

954

Explain the disadvantages of cursors?

1135

What is data source document?

1033

What sql server means?

962

How to perform backup for certificates in sql server? : sql server security

1086

State the difference between union and union all?

926

What are the advantages of using a stored procedure?

1002

How we can compare two database data?

938

what are defaults? Is there a column to which a default can't be bound? : Sql server database administration

1128

what is raid? : Sql server database administration

1036

Explain can you implement data mining in ssrs?

158