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
- 68772 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 clustered indexes can be created on a table? : Sql server database administration
How to execute stored procedure and set temp table in sql server?
How to populate a table in sql server?
What is the significance of null value and why should we avoid permitting null values?
How to change the name of a database user?
What are the difference between clustered and a non-clustered index?
Why de-normalization required?
What are the results of running this script?
Do you know the isolation level that sql server support?
What do you understand by a stored procedure?
How can we get count of the number of records in a table?
What is difference between views and stored procedures?
What is fill factor and pad index?
Explain filtered indexes benefits?
What is join and name different type of joins?
