I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62832 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / madan
This ans. particularly when you want 2nd highest marks?
and not for nth highest marks.
SELECT MAX(mark) FROM student WHERE mark <
(SELECT MAX(mark)FROM student)
| Is This Answer Correct ? | 18 Yes | 7 No |
Post New Answer View All Answers
Which language is supported by sql server?
What xml support does the sql server extend?
What is the difference between a local and a global temporary table?
What is identity?
What are the differences between char and nchar in ms sql server?
Using the customer, and order table in northwind database, please write a query to produce xml?
What is a transaction and why is it important?
Explain can you implement data mining in ssrs?
How to use the inserted and deleted pseudo tables?
How do I find sql server instance name?
What happens if you insert a duplicate key for the primary key column in ms sql server?
How to loop through result set objects using mssql_fetch_array()?
What is a filestream?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
How to delete exactly duplicate records from a table?
