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

What are all the differences between dispose and finalize()?

649


Which properties are used to bind a DataGridView control?

658


Explain about delegate?

583


What are the differences between server-side and client-side code?

605


Can you please explain the difference between authentication and authorization?

617






Name and explain some of the exclusive features which are present in vb?

624


What is redim keyword?

654


What is redim keyword and its use?

675


When do you use virutal keyword?

672


Explain how to store decimal data in .net?

811


Tell us how many languages are supported by .net?

594


how to get dynamic control array position or its index position?

2124


List the two main parts of .net?

676


Write a VB.Net console program to check whether a number is perfect or not.

7096


Explain cls?

669