GuitarGod Posted May 8, 2009 Share Posted May 8, 2009 Hi all, Let's say I have a basic SQL which selects some things from a table. Let's also say the SQL will return 50+ rows. Is it possible to add something to the SQL string that will ignore the first 10 rows and just return the rest of the results? I know I could just return all the results and use other PHP methods to ignore the first 10 rows, but it would be better if I could add something to the SQL statement. Sorry if you didn't get what I mean. Any ideas? Thanks Link to comment https://forums.phpfreaks.com/topic/157380-solved-is-this-possible-in-sql/ Share on other sites More sharing options...
Ken2k7 Posted May 8, 2009 Share Posted May 8, 2009 Yes, there is LIMIT! Link to comment https://forums.phpfreaks.com/topic/157380-solved-is-this-possible-in-sql/#findComment-829625 Share on other sites More sharing options...
GuitarGod Posted May 8, 2009 Author Share Posted May 8, 2009 I was just about to post saying that I've found the answer. But thank you all the same I'm very sorry I should have done more research before posting. Link to comment https://forums.phpfreaks.com/topic/157380-solved-is-this-possible-in-sql/#findComment-829627 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.