sql satement for 2nd maximum value

Answer Posted / archana chavan

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

Is This Answer Correct ?    18 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain internal keyword in .net framework?

575


i have two class that contain's two methods as same name in derived class i have to call these two methods what will happen at run time ?

2250


What is code security?

535


What does assert() method do In VB.NET

544


Explain how the .net framework performs automatic memory management.

574






How to connect crystal report in vb.net ?

581


What is portable executable?

588


What are option strict and option explicit?

802


What is branching logic control in VB.NET?

577


What is misl code?

579


Explain clr?

579


Is vb net a scripting language?

559


Name the tool which can convert visual basic old version to .net compatibility version?

528


What is early binding?

535


What are the two main parts of .net?

579