- 论坛徽章:
- 0
|
大家好 ,
我有一个数据表如下
ID Cate. Word
1 Sports basketball
2 Sports football
3 SPorts volleyball
4 Economy share
5 Economy bank
6 Economy credit
7 Economy basketball
8 Society credit
9 Society democracy
10 Society people
11 Society basketball |
我想找出那些在少于3个 类别中 出现的词.比如在上例中,查询结果应该是 除了与'basketball'对应的3个 记录(记录1,7,11) 之外的所有记录,
我使用下面的命令
- Select *
- From TableName
- Group By
- Word
- Having Count(*)<3
- Order by
- Cate
复制代码
但 对于 'credit' 而言,只有一条记录,即
对于 'credit' 而言,正确的查询结果应含有2条记录,即
- 6 Economy credit
- 8 Society credit
复制代码
请大家帮忙,如何才能得到我想要的答案。谢谢
[ 本帖最后由 cy163 于 2009-6-1 13:41 编辑 ] |
|