Something

select is SELECT DISTINCT `s`.`sid`, `s`.`name` AS `sname`, `r`.`rid`, `r`.`rdate`, `c`.`name`, `s`.`status`, `r`.`rdate`, `r`.`rid`, `c`.`name` FROM `student` AS `s` INNER JOIN `registration` AS `r` ON s.sid = r.sid INNER JOIN `student_course_interests` AS `sc` ON s.sid = sc.sid INNER JOIN `course` AS `c` ON c.cid = sc.cid GROUP BY `s`.`sid` LIMIT 5 OFFSET 2// Is there a better way of using the LIMIT clause? This statement is used to paginate the results in a PHP application