请问下高手。。有没有办法能够将三条语句写成一条语句 查询出结果SELECT COUNT(UserId) FROM User
WHERE CreateDate BETWEEN _StartTime AND _EndTime;
SELECT COUNT(UserId) FROM User
WHERE Email <> '' AND CreateDate BETWEEN _StartTime AND _EndTime;
SELECT COUNT(UserId) FROM User
WHERE Email <> '' AND IsEmailVerified = 1 AND CreateDate BETWEEN _StartTime AND _EndTime;
WHERE CreateDate BETWEEN _StartTime AND _EndTime;
SELECT COUNT(UserId) FROM User
WHERE Email <> '' AND CreateDate BETWEEN _StartTime AND _EndTime;
SELECT COUNT(UserId) FROM User
WHERE Email <> '' AND IsEmailVerified = 1 AND CreateDate BETWEEN _StartTime AND _EndTime;
解决方案 »
- windows下如何安装和使用ZRM for MySQL?
- 多个存储过程的执行顺序
- 想了一天了,这个SQL仍然不知道怎么写..有更高的高手来帮下!
- 求一条insert sql写法
- 如何导入frm文件至MySql数据库
- MySQL安装配置过程中出现can't connect to mysql server on localhost 10061的错误
- 我的mysql无法启动,1067错误,这是怎么回事啊?
- 【新手】数据库的选择,以及是否应当使用数据库
- 2张表能否搞定描述标签
- MYSQL 计算同比 环比 并按月统计
- 问一个mysql mysqldump 备份的问题
- 如何把现有的execl表导入mysql数据库里
WHERE CreateDate BETWEEN _StartTime AND _EndTime
union all
SELECT COUNT(UserId) FROM User
WHERE Email <> '' AND CreateDate BETWEEN _StartTime AND _EndTime
union all
SELECT COUNT(UserId) FROM User
WHERE Email <> '' AND IsEmailVerified = 1 AND CreateDate BETWEEN _StartTime AND _EndTime;
类似于 select a,b,c from table; 直接取得a,b,c三个参数。
select
(
(select COUNT(UserId) From User WHERE CreateDate BETWEEN '1999-0-0' AND '2012-0-0') ,
(SELECT COUNT(UserId) FROM User WHERE Email <> '' AND CreateDate BETWEEN '1999-0-0' AND '2012-0-0'),
(SELECT COUNT(UserId) FROM User WHERE Email <> '' AND IsEmailVerified = 1 AND CreateDate BETWEEN '1999-0-0' AND '2012-0-0')
);我原本打算这样写的,不过报错了。哎 请大神在帮帮忙吧 帮我看看改如何去改。。
(select COUNT(UserId) From User WHERE CreateDate BETWEEN '1999-0-0' AND '2012-0-0') a ,(SELECT COUNT(UserId) FROM User WHERE Email <> '' AND CreateDate BETWEEN '1999-0-0' AND '2012-0-0') b ,(SELECT COUNT(UserId) FROM User WHERE Email <> '' AND IsEmailVerified = 1 AND CreateDate BETWEEN '1999-0-0' AND '2012-0-0') c
;这样?