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
- 68515 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / dolat ram
select max(mark) from student where mark < (select max
(mark) from student)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How do I setup a local sql server database?
How to generate create table script on an existing table in ms sql server?
How will you optimize a stored procedure optimization?
Explain various data region available in ssrs with their use?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What do you mean by 'normalization'?
How many types of dimensions are there and what are they? : sql server analysis services, ssas
What is report snapshot in ssrs?
What the difference between UNION and UNIONALL?
How to display a past time in days, hours and minutes?
Why SQL Agent is used?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
what is isolation level at dead lock?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How to rename databases in ms sql server?
