rameshfaj Posted June 3, 2008 Share Posted June 3, 2008 Can I use the dynamic value for the limit. Ex: select name from my_table Limit(Select count(id) from my_table). Link to comment https://forums.phpfreaks.com/topic/108532-solved-mysql-limit/ Share on other sites More sharing options...
fenway Posted June 3, 2008 Share Posted June 3, 2008 No... you'll have to do it in 2 queries. Link to comment https://forums.phpfreaks.com/topic/108532-solved-mysql-limit/#findComment-556662 Share on other sites More sharing options...
rameshfaj Posted June 4, 2008 Author Share Posted June 4, 2008 Thanks using two queries can be done easily,but I was searching if one query can be used. Link to comment https://forums.phpfreaks.com/topic/108532-solved-mysql-limit/#findComment-557189 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.