SQL查询返回错误的列

Question

我试图找出如何从SQL表只返回唯一值，这里的命令字符串：SELECT DISTINCT Rep FROM Inventory，唯一的一点是，它从一个完全不同的列返回的数据...任何线索？

结构：

invoice int 
boxNum nvarchar 
ICCID nvarchar 
KIT nvarchar 
Network nvarchar 
Supplier nvarchar 
Capturer nvarchar 
Region nvarchar 
TimeIn Date 
TimeAssigned date 
Rep nvarchar 
OrderCode nvarchar 
TimeDistributed Date 
ShopInfo nvarchar 
TimeACtivated Date 

查询返回的ICCID列

注：我使用的SQL Server Express 2008 R2。
库存是一个表

事情我已经尝试：

SELECT DISTINCT Rep FROM Inventory (returns ICCID) 

SELECT Rep FROM Inventory (returns all reps) 

SELECT Rep FROM Inventory ORDER BY Rep (returns ICCID in orderN) 

SELECT DISTICNT ICCID FROM Inventory (returns ICCID in orderX) 

SELECT Rep FROM Inventory WHERE Rep ='aRepsName' (returns one field with the rep's name) 

后多挠头和建议，我决定看看实际的数据，似乎我在某个时候更新错误的列过去。我很抱歉致密。

Answer 1

Rep列中的ICCID数据盲目（读取愚蠢）插入操作