I have student marks in a student table. I need second
highest mark .Then what will the query for this?
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
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
Do you know the cursor types?
What is resultset concur_updatable?
What are the disadvantages of indexes?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
What are the different kinds of ssrs reports?
How should i optimize the time for execution of stored procedure having single input and many output from the different tables?
Explain error handling in ssis?
How to make conditional sum in ssrs?
How can we delete Duplicate row in table?
What are the advantages of using cte?
Can we use max in where clause?
What do you know about system database? : SQL Server Architecture
Tell me what do you understand by a view? What does the with check option clause for a view do?
What are the types of normalization?