MySQL: SELECT highest column value when WHERE finds similar entries

MySQL: SELECT highest column value when WHERE finds similar entries

References

Reference NO 1

http://stackoverflow.com/questions/13582789/mysql-select-highest-column-value-when-where-finds-similar-entries

Reference NO 2

http://stackoverflow.com/questions/18280138/select-rows-the-the-second-highest-value-in-a-column

Reference NO 3

http://stackoverflow.com/questions/6560000/sql-selecting-rows-where-column-value-changed-from-previous-row

Reference NO 4

http://stackoverflow.com/questions/12235595/find-most-frequent-value-in-mysql-column

Reference NO 5

http://stackoverflow.com/questions/16695858/find-records-where-field-is-greater-than-all-values-in-a-set-in-mysql

Reference NO 6

http://dev.mysql.com/doc/refman/5.1/en/example-maximum-column-group-row.html

Reference NO 7

#EANF#

Reference NO 8

#EANF#