I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62938 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sarika
select max(mark)
from student
Having max(mark)<(select max(mark)
from student)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain primary key?
What is the meaning of lock escalation and why/how to stop this? : sql server database administration
Are connections to sql server encrypted?
what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration
What is a non-clustered index?
Does an index slow down updates on indexed columns?
What are the limitations/drawbacks or ssrs 2008 r2?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is the difference between stored procedure and functions?
What are the main sources of data?
What are the grouping functions?
What is the command to change the recovery model?
How to skip remaining statements in a loop block using continue statements?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What does asynchronous call backs means?
