***************高难改的distinct

[kelly_1127]

sql="select distinct(name),address,company from name where company<>'' and address<>'' "

这句话中,我想得出distinct(name),但又不能得到address,company ,怎么改啊

[GageCSDN]

select distinct [name],address=(select top 1 address from [name] where [name]=a.[name]),company=(select top 1 company from [name] where name=a.[name]) from [name] a where company<>'' and address<>''

[zhengxionghua1983]

不知道是你表达的不清楚。还是我的理解能力差。真不明白你在说什么。你是想得到不重复元组信息还是想得到你给出的字段的这此信息都要显示。还是别的。