使用SQL获取不同的计数?
问题描述:
简单SQL为你SQL专家。使用SQL获取不同的计数?
我有两个字段(AccountNo,CheckNo)。可以有多个具有相同值的checkno。它将具有相同的帐号。我希望从mytable中显示AccountNo和CheckNo的列表,以及它存在多少次的次数。
Select Distinct AccountNo, CheckNo, Count(Distinct AccountNo, CheckNo) as Total
from MyTable
答
你是什么后GROUP BY
Select AccountNo, CheckNo, Count(*) as Total
from MyTable
group by AccountNo, CheckNo
答
Select AccountNo, CheckNo, Count(*) as Total
from MyTable
group by AccountNo, CheckNo
+0
`Count(AccountNo,CheckNo)`=>语法无效。现在它已经被编辑了,它和我的答案完全一样,甚至下至三线。 – RichardTheKiwi 2011-02-14 21:16:33
SELECT DISTINCT AccountNo,CheckNo,从MyTable的GROUP BY AccountNo,CheckNo数(1)总??? – CarneyCode 2011-02-14 21:15:45