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

What is the difference between convert.tostring and .tostring() method?

605

What is the difference between Namespace and Assembly?

660

Observations between vb.net and vc#.net?

656

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

571

What is datatype conversion?

622

What are different types of jit ?

673

Allowed program to auto-correct the database when loading a presentation.

1819

What do you mean by deserialization?

637

what is diffrence constructor and destructor in vb

628

What is the class that allows an element to be accessed using unique key?

625

Explain convert.tostring and i.tostring method?

597

Why should you use delegate?

538

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

713

What is the purpose of objects present in asp.net?

643

Explain the advantage of option strict on?

605