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 redim keyword and its use?

586


What is the difference between manifest and metadata?

546


What is a stream in vb.net?

526


What is enumerator?

565


what is difference between web.config and machine.config and where it will be ?

481






How to store decimal data in .net?

639


What is sealed class?

603


Explain convert.tostring and i.tostring method?

527


What is non_deterministic finalization?

620


What do you mean by option strict on?

662


List the types of authentication?

533


Compare c# and visual basic.net?

546


Explain the use of serialization and deserialization?

513


What is the top .net class that everything is derived from?

614


Explain option explicit?

558