sql satement for 2nd maximum value

Answer Posted / kaushal gajjar

select top 1 UnitsInStock
from products
where UnitsInStock in (select top 2 UnitsInStock from
products order by UnitsInStock desc)

Is This Answer Correct ?    4 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How does vb.net achieve polymorphism?

541


What is redim keyword and its use?

589


How can we remove handlers at run time?

539


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

568


Explain i.tostring method?

524






What is sorting in vb?

526


I Am Developing A project where I can send Message from One Computer to Another Computer With The Help Of LAN.Already I Have developed..It is working Fine With The Details Of ..TO,FROM,REF No,DATE,BODY...Now I Want To Add Attachments part in the same projects...How Can I Send Attachment File & How To Send It..I Am Working in VB.Net 2005 With out Any database. Can Any One Help me ??How To Write Code??Plz Send me a copy to my Mail also...I Dont Need Any Software Available in The Internet...Plz refer me The Code in VB.Net maloy.adhikari@in.com

2212


Why do we use byref keyword in vb.net?

601


What is pre-jit?

541


What is the difference between Namespace and Assembly?

581


What is redim keyword?

577


Write program in VB.Net with SQL Server and Crystal Reports to develop a small windows application to add,edit,save, search and print Employee Information and send sourcecode as zip file. empcode : .............. empname : .............. dateofjoin : dd/mm/yyyy dateofbirth : dd/mm/yyyy TableName: EmpMaster EmpCode EmpName DOB DOJ TableName: EmpDocs EmpCode DocNo DocName ExpDate

2190


What is the use of errorprovider control?

597


Explain the difference between namespace and assembly?

514


Explain about the feature anonymous type?

619