sql satement for 2nd maximum value

Answer Posted / rohan patil

Select * from author where rownum=2
order by ID desc

Is This Answer Correct ?    5 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the main purpose of garbage collector?

506


Why should you use delegate?

477


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

566


What are the advantages of vb.net and c#?

640


What is the difference between manifest and metadata?

550






Explain option explicit?

560


my project run very wel in my sytem yhen i am deploying my project on client machine ,after deployment i run my project then it show " can no find server name " what i do .

1559


What is the difference between custom control and user control?

554


Explain trace in vb.net?

523


How many languages are supported by .net?

552


How vb implements the disconnected architecture as like vb.net?

585


Explain how the .net framework performs automatic memory management.

568


Why do we use byref keyword in vb.net?

602


Explain convert.tostring and i.tostring method?

533


How to store images in sql server database through vb.net?

505