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 Quote 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! Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.