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 do you mean by serialization and deserialization?

699

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

698

What is datatype conversion?

712

Explain about branching logic control in vb.net?

691

What are jagged arrays ?

714

Described strong typing

723

What is meant by jagged arrays?

746

Explain public assembly?

701

Which classes a dll can contain?

712

How to achieve Polymorphism in VB.Net?

782

So you know which dll is used for microsoft .net run time?

712

Explain the use of serialization and deserialization?

714

Explain the difference between thread and process?

668

What is the advantage of using system.text.stringbuilder over system.string?

800

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

744