author is Table name ID is column name select top 1 * from author where

sql satement for 2nd maximum value

Question Posted / murli d

Answer Posted / murli d

author is Table name
ID is column name

select top 1 * from author where ID < (select max(ID)
from author) order by ID desc

Is This Answer Correct ?

16 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are jagged arrarys ?

980

What is the use of errorprovider control?

1007

Name some of the keywords used in vb.net?

1024

What are the different types of applications supported in .net (or) .net framework?

948

Explain and brief about rapid application development tool?

1022

How to connect crystal report in vb.net ?

936

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

1054

Explain private assembly?

933

List the types of authentication?

916

Explain convert.tostring and i.tostring method?

924

What is the difference between custom control and user control?

999

What is the importance of a Button control?

1306

What is the use of assembly?

1002

Explain the use of new keyword?

928

Explain about the keyword must inherit?

982