select top 1 UnitsInStock from products where UnitsInStock in (select t

sql satement for 2nd maximum value

Question Posted / kaushal gajjar

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

Please Help Members By Posting Answers For Below Questions

Explain the difference between int and int32?

876

Explain the difference between datatable and dataset?

1171

Name the tool which can convert visual basic old version to .net compatibility version?

979

What is the differences between dataset.clone and dataset.copy?

1047

Explain the use of serialization and deserialization?

1009

Explain about the feature anonymous type?

943

Explain an assembly and its use?

964

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

1041

What are the difference between structure and class?

1066

Explain an assembly?

913

What is the difference between Namespace and Assembly?

1050

Explain how the .net framework performs automatic memory management.

946

Why do we use ansi keyword?

922

i am attending to US consulate i kept my projects on vb.net ,please help me what questions will be ask on vb.net in us consulate

2295

Explain the use of console application?

919