Get first or most repeated value from a group by in SQL Server

Get first or most repeated value from a group by in SQL Server

References

Reference NO 1

http://stackoverflow.com/questions/13635614/get-first-or-most-repeated-value-from-a-group-by-in-sql-server

Reference NO 2

http://stackoverflow.com/questions/5225113/how-to-get-first-record-out-of-each-group-from-the-result-retreived-by-using-gro

Reference NO 3

http://www.sql-server-performance.com/2006/find-frequent-values/

Reference NO 4

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138606

Reference NO 5

http://www.sqlservercentral.com/Forums/FindPost925433.aspx

Reference NO 6

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f0b3df4a-8dc3-4971-baa8-b0f0b6fde854/action?threadDisplayName=need-help-with-some-sql-statements-find-most-frequent-value-in-column

Reference NO 7

http://sqlserverplanet.com/tsql/find-duplicate-fields-in-a-table

Reference NO 8

#EANF#