SQL Server选择不同的地狱

我陷入了sql问题.我有一个表，其中有许多重复的条目，其列名如下:-

I'm stuck on a problem with sql. I have a table with many duplicate entries with column names like:-

eventnumber housenumber value1 value2

这些列名都不是主键，因为有很多重复项.我想做的是通过不同的门牌号选择另一个表，但是我似乎在复制整个表，我正在使用:-

None of these column names are the primary key as there are many duplicates. What I would like to do is select into another table by distinct housenumber but I seem to get the whole table copied across, I'm using:-

Select * into temp_table from schedule_temp where housenumber in (select distinct housenumerb from schedule_temp)

现在我将其分解一下，如果我这样做了:-

Now I broke it down a bit and if I do:-

Select distinct housenumber into temp from schedule_temp group by housenumber

我得到了一个具有唯一门牌号的表...但是然后我如何使用这个唯一表来驱动另一个选择，该选择从temp中选择门牌号，而仅从schedule_temp中获得一个门牌号的实例?希望有道理.

I get a table with the unique housenumbers... but then how could I use this unique table to drive another select that picks housenumbers from temp and only gets one instance of the housenumber from schedule_temp? Hope that makes sense.

如果您能挽救我的理智，啤酒就在我身上.

Beers are on me if you can save my sanity.