SELECT TOP 1 Marks (SELECT TOP 2 Marks from Tablename Order by Marks Desc

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

Question Posted / dharmendra k. dixit

37 Answers
69876 Views
NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
E-Mail Answers

Answer Posted / dharmendra k. dixit

SELECT TOP 1 Marks (SELECT TOP 2 Marks from Tablename Order
by Marks Desc)From Tablename order by Marks Asc

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain about SQL server 2005?

1026

Explain can SSRS reports Cache results?

161

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2629

What is a scheduled job or what is a scheduled task?

1008

How you provide security to cube? : sql server analysis services, ssas

1009

What is an indexing strategy?

1066

What are the diifferences between the ms sql server vs mysql?

1235

What is lookup override?

1079

What does it mean to normalize a database and why would you do it?

1024

What is snapshot report?

172

New concepts of sql server 2005 use in your project.

2401

How except clause is differs from not in clause?

1008

difference between Clustered index and non clustered index ?

1035

Write a program to fetch first 10 records from a file?

1062

What are extended events in sql server?

1007