asp中如何用sql提取表中不重复项的个数？

sql="select Count（Distinct 列名) as total from 表名"
是不是这个？

补充，你把User_id加上[]试试
select count(distinct [User_ID]) as total from xyqj_log

语法应该没有什么问题，刚刚在数据库测试过

select sum(cnt) as cnt
from (select ?,?,?, count(*) as cnt
from 表名
group by ?,?,?
having count(*) = 1 )

sql="select distinct item3333 as total from 表名"