table1
[col1]
aaaaaaaa
bbbbbbbb
cccccccc
DDDDDDDD
aaaaaaaa
aaaaaaaa
bbbbbbbb
bbbbbbbb
aaaaaaaa
aaaaaaaa
aaaaaaaa返回结果:不重复
aaaaaaaa
bbbbbbbb
cccccccc
DDDDDDDD
[col1]
aaaaaaaa
bbbbbbbb
cccccccc
DDDDDDDD
aaaaaaaa
aaaaaaaa
bbbbbbbb
bbbbbbbb
aaaaaaaa
aaaaaaaa
aaaaaaaa返回结果:不重复
aaaaaaaa
bbbbbbbb
cccccccc
DDDDDDDD
create index ix_col1 on table1(col1)select distinct col1 from table1
你这个字段是干嘛的设那么大orz