ballouta Posted July 17, 2009 Share Posted July 17, 2009 kindly i need to select only two rows of the 'table' books after ordering the id by Desc please help thank you Quote Link to comment https://forums.phpfreaks.com/topic/166322-solved-query-help/ Share on other sites More sharing options...
kickstart Posted July 17, 2009 Share Posted July 17, 2009 Hi Use the LIMIT clause. Eg, SELECT Id, BookName FROM Books ORDER BY Id DESC LIMIT 0,2 All the best Keith Quote Link to comment https://forums.phpfreaks.com/topic/166322-solved-query-help/#findComment-877058 Share on other sites More sharing options...
ballouta Posted July 17, 2009 Author Share Posted July 17, 2009 thanks alot Quote Link to comment https://forums.phpfreaks.com/topic/166322-solved-query-help/#findComment-877059 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.