I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62933 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sanah
select top 1 marks from marks where marks
<(select max(marks) from marks) order by 1 desc
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
How to use linked server?
What is your recommendation for a query running very slow? : sql server database administration
Is natural join and equi join same?
How do you manipulate data?
How to turn off warning messages during php execution?
How to optimize stored procedure optimization?
What is the purpose of grouping data in a report?
What is plan freezing?
In what three ways is the return statement used in a stored procedure?
Does partitioning help performance?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
Explain having clause?
What happens when unicode strings concatenate with non-unicode strings?
Explain what is dbcc?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
