sql distinct with multiple columns

sql distinct with multiple columns

References

Reference NO 1

http://stackoverflow.com/questions/54418/how-do-i-or-can-i-select-distinct-on-multiple-columns

Reference NO 2

http://www.w3resource.com/sql/select-statement/queries-with-distinct-multiple-columns.php

Reference NO 3

http://www.neowin.net/forum/topic/974024-sql-select-multiple-columns-with-only-one-distinct-column/

Reference NO 4

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

Reference NO 5

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

Reference NO 6

http://www.databasechannel.com/AccessArticles/Article_DISTINCT_MultipleColumns.html

Reference NO 7

http://forums.asp.net/t/prev/1469184

Reference NO 8

http://answers.yahoo.com/question/index?qid=20081016000937AAJ3xS2