GROUP BY mysql showing only one row. But want repetitions also

GROUP BY mysql showing only one row. But want repetitions also

References

Reference NO 1

http://stackoverflow.com/questions/15198185/group-by-mysql-showing-only-one-row-but-want-repetitions-also

Reference NO 2

http://stackoverflow.com/questions/13767749/group-by-show-only-first-occurrence-if-value-equals

Reference NO 3

http://www.plus2net.com/php_tutorial/record-list.php

Reference NO 4

http://www.databasejournal.com/features/mysql/article.php/3911786/Eliminating-Duplicate-Rows-from-MySQL-Result-Sets.htm

Reference NO 5

http://www.tutorialspoint.com/mysql/mysql-handling-duplicates.htm

Reference NO 6

http://forums.phpfreaks.com/topic/277915-generate-non-repetition-datas-from-database/

Reference NO 7

http://dba.stackexchange.com/questions/20335/can-mysql-reasonably-perform-queries-on-billions-of-rows

Reference NO 8

http://www.tech-recipes.com/rx/1481/ignore-duplicate-entries-in-mysql-select-using-distinct-keyword/