Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

sql satement for 2nd maximum value

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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 .

2060


source code for how to login a vb.net application ?

1038


Explain trace in vb.net?

974


What is internal keyword in .net framework?

1035


What do you understand by vb.net?

1041


Explain jit?

1093


What are the parts of the visual basic control?

951


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

970


Explain code security?

925


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

1062


What are option strict and option explicit?

1371


Explain the difference between int and int32?

937


what is intermediate language?

1034


Explain about Visual basic.NET culture?

988


Define serialization in .net?

1185