I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 63000 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
How to recover from sql injection? : sql server security
What are acid properties of transaction?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Explain about remote stored procedure?
Do you know data definition language, data control language and data manipulation language?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is a not null constraint?
what data regions are and what are the different data regions?
Is candidate a key?
How can you stop stored procedures from recompiling?
what are the important architecture components of SSRS?
How to use linked server?
‘Order by’ is not allowed in a view how can you sort information from a view?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is the difference between migration and upgradation in sql server?
