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

What is the difference between compiler and interpreter?

726


Explain how to send xml file on server using http protocol?

657


What are the technology areas that microsoft.net contains?

748


What is deep copy?

723


Explain about delegate?

663






Name some of the keywords used in vb.net?

759


Can you please explain the difference between dataset and datareader?

745


Thank you for replying to my Question regarding Barcodes in VB.net. My next question is that how to use Barcode Fonts in VB.net I need a small code to Generate Barcodes in VB.net from a string of Values. This is the only problem i am left with in my project. Any body can help me please.

2220


What is a literal control?

717


What is the significance of delegates. Where should they be used? What are the situations where we require them?

729


What is public assembly?

727


Explain about visual basic?

717


How many languages are supported by .net?

708


How to achieve Polymorphism in VB.Net?

782


Explain namespace?

737