select top 1 * from (select top 2 marks from student order by marks desc)a

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

Question Posted / maheswar reddy s

Answer Posted / maheswar reddy s

select top 1 * from (select top 2 marks from student order by marks desc)a order by marks

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the difference between Stored Procedures and triggers?

1031

when would you go for denormalization? : Sql server database administration

809

Can primary key be a foreign key?

995

What is hot add cpu in sql server 2008?

883

what is nonclustered index

892

What is sql or structured query language?

1085

Define inner join? Explain with an example?

923

How do I make a resultset scrollable?

908

What is subquery? Explain the properties of a subquery?

924

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2025

what type of index will get created after executing the above statement? : Sql server database administration

919

What is entity data services?

1002

What is an index in a database?

920

Explain activity monitors

1001

Does a server store data?

861