SELECT BorrowerMemNo AS BMN
FROM Book
WHERE 6=(SELECT COUNT(*)
FROM Book
WHERE BorrowerMemNo=BMN);
这样会出来6条相同的纪录但是如果加个distinct
SELECT DISTINCT BorrowerMemNo AS BMN
FROM Book
WHERE 6=(SELECT COUNT(*)
FROM Book
WHERE BorrowerMemNo=BMN);
返回为空,一条纪录都没
求问阿,困扰好几天了
FROM Book
WHERE 6=(SELECT COUNT(*)
FROM Book
WHERE BorrowerMemNo=BMN);
这样会出来6条相同的纪录但是如果加个distinct
SELECT DISTINCT BorrowerMemNo AS BMN
FROM Book
WHERE 6=(SELECT COUNT(*)
FROM Book
WHERE BorrowerMemNo=BMN);
返回为空,一条纪录都没
求问阿,困扰好几天了
解决方案 »
- mysql复制的问题
- 引用两个表的sql语句的问题
- Fedora 8下安装MySQL
- 怎样查询最近5天的记录呢?
- JDBC里的预处理语句怎么用?
- 为什么我建立一个表后,机器重启就不见了
- VC使用mysql时编译是出错!
- Windows下没有生成慢查询日志
- 一个简单的SQL查询问题
- MySQL 4200 the used command is not allowed with this MySQL version
- SQL Server不存在或网络拒绝访问,请问这是怎么回事?很急,求求大家了
- [100分]在windows2003上制作的jsp网站,过两天数据库就死掉了,系统必须重起,mysql才可用!!
FROM Book这个的时候已经不是6条记录了。后面再等于6,那当然是不对了。
SELECT DISTINCT BorrowerMemNo AS BMN
FROM Book
WHERE 0=(SELECT COUNT(*)
FROM Book
WHERE BorrowerMemNo=BMN);
怎么一加distinct差别这么大
SELECT BorrowerMemNo AS BMN
FROM Book
WHERE 6=(SELECT COUNT(*)
FROM Book
WHERE BorrowerMemNo=BMN) GROUP BY BorrowerMemNo
这样再试一下.