sql="select distinct top 20 company.name,zp.*,company.id from zp inner join company on zp.cID=company.id where company.ispub=1 order by zp.idate desc"就是这句了,我想把重复的company.name不要查询出来,要怎么做?
select distinct name --可以添加其他字段,如果ID为唯一标示列,则ID不要添加 from table
select * from table group by name
加上top 20就出错了,怎么办?
--这样试一下! sql="select distinct top 20 Max(company.name) as name,zp.*,company.id from zp inner join company on zp.cID=company.id where company.ispub=1 order by zp.idate desc"
如果ID是唯一标示列,需要用Max或者Min选一个出来,不然必定出现重复Name的数据
sql="select top 20 Max(company.name) as name,zp.*,company.id from zp inner join company on zp.cID=company.id where company.ispub=1 order by zp.idate desc"
distinct name --可以添加其他字段,如果ID为唯一标示列,则ID不要添加
from table
sql="select distinct top 20 Max(company.name) as name,zp.*,company.id from zp inner join company on zp.cID=company.id where company.ispub=1 order by zp.idate desc"
from zp inner join company on zp.cID=company.id where company.ispub=1 order by zp.idate desc"