Oredrs is table name orderid is collum name select top 1 * from Order

sql satement for 2nd maximum value

Question Posted / chandru teamwork

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

Please Help Members By Posting Answers For Below Questions

Explain redim keyword?

645

Explain the difference between import system.data.sqlclient and system.data.oledb?

630

Is vb net a scripting language?

635

What is stack used for in vb. Net?

611

What do you understand by vb.net?

688

List the two main parts of .net?

678

List the types of generations in garbage collector?

606

Which class allows an element to be accessed using unique key?

597

What is non_deterministic finalization?

713

Define manifest?

647

What is the maximum size of the textbox?

611

Explain the use of serialization and deserialization?

611

What is enumerator?

646

Explain the difference between namespace and assembly?

589

Explain trace in vb.net?

610