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

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

559

Name the two main parts of .net?

521

Using VB, how can you change the Mouse Pointer?

637

What is the use of system.diagnostics.process class?

564

How to execute VB.NET PROJECTS,VB6.0 PROJECTS AND write their test cases.Need Reply Urgently

1995

what is commom language runtime?

553

Which control is an example of an object in vb net?

6453

What is the strong name in .net assembly?

566

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

525

Explain some of the exclusive features which are present in vb?

515

Name some of the features present in vb 2005?

570

Explain option strict?

551

Explain the components of common language runtime.

519

Explain an assembly?

571

What is sorting in vb?

524