If you want to know how to SET LIMIT in Joomla Database using PHP? Use the following code to use LIMIT in getQuery.
$db = JFactory::getDBO();
$query = $db->getQuery(true);
$rows = $db->loadObjectList();
If you like this question & answer and want to contribute, then write your question & answer and email to freewebmentor[@]gmail.com. Your question and answer will appear on FreeWebMentor.com and help other developers.