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

What is the significance of delegates. Where should they be used?

951

Can you please explain the difference between thread and process?

982

How to send xml file on server using http protocol?

996

What is the top .net class that everything is derived from?

1063

Explain i.tostring method?

930

Explain about globalization?

873

Can you please explain the difference between vb and vb.net?

894

how to deploy vb.net with key and evaluation time? any one can help me?

2210

How to execute VB.NET PROJECTS,VB6.0 PROJECTS AND write their test cases.Need Reply Urgently

2506

Why should you use delegate?

916

Explain how to send xml file on server using http protocol?

874

Explain an assembly and its use?

1020

Explain the advantage of option strict on?

926

what is common type system?

909

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

955