|
LarryC74
Yak Posting Veteran
83 Posts |
 Posted - 11/17/2012 : 18:41:49
|
Create Table #TempTable
(Sentence int,
person varchar(10),
country varchar(25)
)
Insert into #TempTable Values(1,'tom','America')
Insert into #TempTable Values(2,'Mark','China')
Insert into #TempTable Values(1,'tom','America')
Select * From #TempTable
Select Distinct *
From #TempTable
Everyday life brings me back to reality |
 |
|
combine rows into distinct values
