I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62881 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / siva prakasam
SELECT TOP (1) stuMark
FROM Student
WHERE stuMark < (SELECT MAX(stuMark) FROM Student)
ORDER BY stuMark DESC
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How many triggers are possible per table?
What does dml stand for?
Explain transaction server isolation?
How real and float literal values are rounded?
What is the xml datatype?
How to handle error or exception in sql?
What is a covering index?
Explain a join?
What is an identity column in insert statements?
What is data source object?
Can we store videos inside the sql server table?
What are the properties of the transaction?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
How to verify the port number of the sql server?
What are the types of indexes?
