I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / rias
Select MIN(MARK) from student where mark in (select Top 2
mark from student order by mark desc)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tell me what is difference between clustered and non clustered index?
What is de-normalization and what are some of the examples of it?
Explain nested join?
Tell me what is normalization? Explain different forms of normalization?
Write the SQL query to drop, truncate and delete table.
What is the difference between nvl and nvl2?
What is the federation in sql azure?
How to insert multiple rows with a subquery?
plss anybody specify tha constrian management system in dbms
What are the differences between clustered and non-clustered index?
What are four major operators that can be used to combine conditions on a where clause?
What do you understand by check constraint in sql server?
What structure can you implement for the database to speed up table reads?
What is difference between delete and truncate commands?
What are different types of raid configurations? : SQL Server Architecture