但是要注意的是 distinct 只对整个 select 与 from 中的选项都有效 如果 select distinct fieldname1,fieldname2 from tablename 就不行了◎可以考虑用 select top 1 fieldname1,fieldname2 from tablename group by fieldname1
同意用 select fieldname from tablename group by fieldname
select fieldname from tablename group by fieldname having count(*)=1
select distinct fieldname from tablename
用语句select distinct fieldname from tablename或者 select fieldname from tablename group by fieldname having count(*)=1 看你实际需要选择吧?呵呵
2003赛季CSDN联赛进入最后阶段,年底大抢分~~~~~~~~~~~~~~~~~~~~~
select distinct fieldname from tablename
如果 select distinct fieldname1,fieldname2 from tablename 就不行了◎可以考虑用
select top 1 fieldname1,fieldname2 from tablename group by fieldname1
having count(*)=1
select fieldname from tablename group by fieldname
having count(*)=1
看你实际需要选择吧?呵呵