Here is simple query which shows simple technique to exclude duplicate records from output. In my example I am selecting only first record from duplicate list based on Primary key.<\/p>\n
\r\nSelect * into #tmp1\r\nFrom(\r\nselect 1 as id,'aaa' as name,11 as age \r\nUNION ALL\r\nselect 1 as id,'aaa' as name,12 as age \r\nUNION ALL\r\nselect 2 as id,'bbb' as name,22 as age \r\nUNION ALL\r\nselect 2 as id,'bbb' as name,23 as age \r\nUNION ALL\r\nselect 3 as id,'ccc' as name,33 as age \r\n) a\r\n\r\n\r\nselect a.*,b.* \r\nfrom #tmp1 a \r\nLEFT JOIN \r\n( \r\n SELECT \r\n\t ROW_NUMBER() OVER(PARTITION BY id ORDER BY id,name) AS Row\r\n\t ,id,name,age\r\n FROM \r\n ( \r\n\t SELECT id ,name,age\r\n\t FROM #tmp1\r\n\t where id IN ( SELECT id FROM #tmp1 group by id having count(*)>1 ) \r\n ) all_dups \r\n) b --\/\/dups with counter\r\nON a.id=b.id and a.name=b.name and a.age=b.age --\/\/todo add many more ....\r\nWhere b.Row IS NULL or b.Row=1\r\n\r\ngo\r\n\r\ndrop table #tmp1\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"Here is simple query which shows simple technique to exclude duplicate records from output. In my example I am selecting only first record from duplicate list based on Primary key. Select * into #tmp1 From( select 1 as id,'aaa' as …<\/p>\n