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
- 69879 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ahmed
SELECT TOP 1 student marks
FROM(
SELECT TOP 2 student marks
FROM students_table
ORDER BY student marks DESC) AS emp
ORDER BY student marks ASC;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the boxing and unboxing concept in .net?
What are “lost updates”?
What is oltp (online transaction processing)?
What command would you use to create an index?
What is the maximum size of a row in sql server?
What is exporting utility?
Why truncate is ddl command?
What do you understand by mirroring and mention the advantages of the mirroring?
What are the basic features of a trigger in ms sql server?
What are the types of subscriptions in SQL Server replication?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
What is a covering index?
How can you check the level of fragmentation on a table?
Explain what is the use of custom fields in report?
Can you explain what are commit and rollback in sql?
