Interested to Buy Any Domain ? << Click Here >> for more details...
I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 69872 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
Working with TLogs
Do you know the isolation level that sql server support?
What is the difference between function and stored procedure in sql server?
How to add an address record into adventureworkslt?
How to get @@error and @@rowcount at the same time?
What is the maximum size of a row in sql server?
What are difference between Cluster index and Non-Cluster index?
How many types of the database links?
Explain datetime2 data type in sal server 2008?
What is the difference between set and select?
How to insert data into an existing table?
What is it’s similarity with sql server?
What does top operator do?
How do I connect to sql server database?
How to recreate an existing index in ms sql server?
