SQL get column value associated with max()

SQL get column value associated with max()

References

Reference NO 1

http://stackoverflow.com/questions/9561890/oracle-sql-get-column-value-associated-with-maxcount

Reference NO 2

http://stackoverflow.com/questions/1211954/find-the-row-associated-with-a-min-max-without-inner-loop

Reference NO 3

http://www.w3schools.com/sql/sql_func_max.asp

Reference NO 4

http://bytes.com/topic/sql-server/answers/456828-select-another-column-where-max

Reference NO 5

http://www.w3resource.com/sql/aggregate-functions/max-date.php

Reference NO 6

http://www.codeproject.com/Questions/453451/how-to-select-the-maximum-value-from-multiple-colu

Reference NO 7

http://technet.microsoft.com/en-us/library/ms187751.aspx

Reference NO 8

http://forums.teradata.com/forum/database/3504-selected-non-aggregate-values-must-be-part-of-the-associated-group-error-on-max-