sql satement for 2nd maximum value

Answer Posted / chandru teamwork

Oredrs is table name orderid is collum name


select top 1 * from Orders
where orderid <=(select max(OrderID) from Orders)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a constant in vb.net?

602


What is late binding?

551


Which namespace are used for accessing the data?

649


Explain the difference between thread and process?

516


Explain how does the xmlserializer work?

597






What is the difference between .dll extension and .exe extension files?

613


Which is the base class for all the classes in .net framework?

569


Explain how can we remove handlers at run time?

552


What is the difference between vb 6 and vb.net?

646


What is the main use of a namespace?

516


what's ArrayList in .Net (VB.Net or C#).What's the advantageous using ArrayList.

572


What is the importance of a Button control?

875


Described strong typing

574


What do you mean by serialization and deserialization and it's use.

609


Can you please explain the difference between authentication and authorization?

543