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 is interface and when it is used?

2326

How many ways the function can return values?

1066

Explain the use of new keyword?

981

Explain jit?

1183

Write the role of new keyword?

1202

Explain about the performance of visual basic?

1073

What are the different types of a stream?

1060

Explain internal keyword in .net framework?

1012

How many classes a dll can contain?

1029

What is the use of internal keyword?

1032

What are the difference between structure and class?

1247

Explain strong name in .net assembly?

1036

What is the difference between custom control and user control?

1050

Explain and brief about rapid application development tool?

1064

How to create a constant in vb.net?

1240