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
- 68551 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
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain about temporary stored procedure?
How to enable tcp/ip protocol on a sql server?
Describe how to use the linked server?
What is tabulation?
What is key attribute?
Why variables called the most powerful component of ssis?
Explain subquery and state its properties?
What is CTE in SQL
How do I view a script in sql server?
Give me any three differences between Truncate and Delete.
How do I view a stored procedure in sql server?
How to drop an existing stored procedure in ms sql server?
What is the architecture of ms sql reporting service?
what is the sql equivaent of the dataset relation object ?
