SELECT id FROM
(SELECT from_id as id FROM email
union ALL
SELECT to_id as id FROM email) as tb_email GROUP by id HAVING COUNT(id)>100;
(SELECT from_id as id FROM email
union ALL
SELECT to_id as id FROM email) as tb_email GROUP by id HAVING COUNT(id)>100;
解决方案 »
- mysql数据库索引问题
- mysql配置的apply security setting不成功,提示Connection Error错误
- 求PL/pgSQL问题答案
- null问题!
- MYSQL问题
- 如何从把一张表中的个别数据到另一表中去?
- 求一无限分类的查询SQL语句!
- 在我的phpadmin中总有这句"使用链接表的额外特性尚未激活。要查出原因,请单击此处。"是什么意思呢?
- 谁能帮我看看这个程序有什么问题啊,老说我Segmentation fault (core dumped),是怎么回事呢?
- sqlserver2000能实现查询从n条记录到m条记录的功能(类似与MySql的limit的功能)么?
- MYSQL连接问题
- ?—?—?—?—?—?—如何通过ADO实现对mysql数据库中表的连接并读取记录?
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT from_id as id FROM `email` union ALL SELECT to_id as id
Your MySQL connection id is 2 to server version: 4.0.17-nt
我在PHP中用phpinfo()看了一下,数据库可能是3.23.49 版本的如果我的数据库不支持子查询,该怎么完成我需要的查询?
SELECT count(*), from_id FROM email GROUP BY from_id;
SELECT count(*), to_id FROM email GROUP BY to_id;
FROM email
WHERE SELECT count(*), from_id FROM email GROUP BY from_id AND
SELECT count(*), to_id FROM email GROUP BY to_id;