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

What are the joins in sql server? : sql server database administration

961

Show Practically Sql Server Views are updatable?

1054

What is implicit mode in sql server?

1027

What is 4nf in normalization form?

950

What is the recursive stored procedure in sql server?

965

What are some examples of schemas?

908

How would you choose between a clustered and a non-clustered index?

915

What are .mdf files?

885

Can I save my report as html, excel or word? : sql server management studio

904

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1152

Explain aggregate functions?

1026

How many partitions a clustered index has by default in sql server 2012?

1049

What is the Main Difference between ACCESS and SQL SERVER?

1064

How to disable stored procedure sql server?

1524

Differentiate between a local and a global temporary table?

897