S silverwolf Unregistered / Unconfirmed GUEST, unregistred user! 2002-05-27 #1 已知表Table有四个属性列A,B,C,D 如何用一条语句同时计算出A中不重复属性值的Count数 和A,D中不重复属性值的Count数。
Y Yumpar Unregistered / Unconfirmed GUEST, unregistred user! 2002-05-27 #2 A,D中不重复属性值的Count数? 是不是： select (select count(distinct a) from table ) as ACount, (select count(distinct d) from table ) as dCount
A,D中不重复属性值的Count数? 是不是： select (select count(distinct a) from table ) as ACount, (select count(distinct d) from table ) as dCount
S silverwolf Unregistered / Unconfirmed GUEST, unregistred user! 2002-05-27 #3 谢谢Yumpar，虽然答案不是很准确，当给了我一个思路，问题解决了。
