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 are the advantages of vb.net and c#?

1069

How to retrieve images in sql server database through vb.net?

924

What is the significance of delegates?

888

Explain the advantages of vb.net?

899

What is the exact defination of object?

960

Tell me how many .net languages can a single .net dll contain?

904

Explain option explicit?

962

What is the difference between static or dynamic assemblies?

965

Name a feature which is common to all .net languages?

953

Define naming convention?

972

What is an arraylist?

1044

How do you use two datareaders at the same time in a vb.net windows application ?

1006

Can you please explain the difference between system.string and system.stringbuilder classes?

984

Name the class which allows an element to be accessed using unique key?

953

What is multiple form in vb?

844