If database = sql server: Select top 10 from table order by id desc
If is also possible to limit the nr of records returned trough ADO.NET which is possible for all databases but this solution is a lot less efficient as the one listed above. -----Original Message----- From: shahid bashir [mailto:[EMAIL PROTECTED] Sent: woensdag 15 september 2004 11:35 To: [EMAIL PROTECTED] Subject: [AspNetAnyQuestionIsOk] Query Return Last 10 Records Dears I have table of items with 500 records I want to my query will return only last 10 records but its also possible that I apply a condition due to it requery return 100 records but i want only last 10 records thanks Shahid Bashir _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
