Group the rows that are having the same value in specific field in MySQL

Group the rows that are having the same value in specific field in MySQL

References

Reference NO 1

http://stackoverflow.com/questions/15203058/group-the-rows-that-are-having-the-same-value-in-specific-field-in-mysql

Reference NO 2

http://stackoverflow.com/questions/1786533/find-rows-that-have-the-same-value-on-a-column-in-mysql

Reference NO 3

http://dev.mysql.com/doc/refman/5.1/en/group-by-functions.html

Reference NO 4

https://dev.mysql.com/doc/refman/5.5/en/group-by-extensions.html

Reference NO 5

http://www.techfounder.net/2010/03/12/fetching-specific-rows-from-a-group-with-mysql/

Reference NO 6

http://bytes.com/topic/mysql/answers/915603-how-get-multiple-row-values-having-distinct-column-value

Reference NO 7

http://www.sitepoint.com/forums/showthread.php?811833-Selecting-the-row-having-the-max-value-for-one-field-grouping-by-another-field

Reference NO 8

#EANF#