select top 1 sal from ( select top 2 sal from test order by sal desc ) as

sql satement for 2nd maximum value

Question Posted / cherran

Answer Posted / cherran

select top 1 sal from
( select top 2 sal from test order by sal desc ) as kk order
by sal

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain the difference between an xml "fragment" and an xml "document."

503

What is stack used for in vb. Net?

529

Explain the difference between datatable and dataset?

552

What is different between web.config and machine.config and where it will be ?

558

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

6936

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

614

Explain the difference between vb.net and c#, related to oops concepts?

495

What is the difference between datagrid and gridview?

513

List the types of generations in garbage collector?

525

what's ArrayList in .Net (VB.Net or C#).What's the advantageous using ArrayList.

565

What are the objects in asp.net?

543

How to connect crystal report in vb.net ?

573

What is an arraylist?

582

Which namespace are used for accessing the data?

642

What is tracing?

611