select (SELECT
count(1)
FROM
train t
LEFT JOIN video v on t.id = v.tid
LEFT JOIN videocharacter vc USING(fileid)
LEFT JOIN STATUS s USING(statusid)
where
s.statuslevel='严重'
) serious,
(SELECT
count(1)
FROM
train t
LEFT JOIN video v on t.id = v.tid
LEFT JOIN videocharacter vc USING(fileid)
LEFT JOIN STATUS s USING(statusid)
where
s.statuslevel='中等'
) secondarys,
(SELECT
count(1)
FROM
train t
LEFT JOIN video v on t.id = v.tid
LEFT JOIN videocharacter vc USING(fileid)
LEFT JOIN STATUS s USING(statusid)
where
s.statuslevel='一般'
)
怎么通过一个select查询出来
count(1)
FROM
train t
LEFT JOIN video v on t.id = v.tid
LEFT JOIN videocharacter vc USING(fileid)
LEFT JOIN STATUS s USING(statusid)
where
s.statuslevel='严重'
) serious,
(SELECT
count(1)
FROM
train t
LEFT JOIN video v on t.id = v.tid
LEFT JOIN videocharacter vc USING(fileid)
LEFT JOIN STATUS s USING(statusid)
where
s.statuslevel='中等'
) secondarys,
(SELECT
count(1)
FROM
train t
LEFT JOIN video v on t.id = v.tid
LEFT JOIN videocharacter vc USING(fileid)
LEFT JOIN STATUS s USING(statusid)
where
s.statuslevel='一般'
)
怎么通过一个select查询出来
解决方案 »
- 在mysql数据库已有的表中新建一列,这一列的值为另外一已有数据的列的排名。 求高手sql如何写?
- 微博中如何获取关注的人的信息?
- MYSQL, 按照两列来分组的一条SQL ,求助
- 请教一个SQL语句
- mysql带参数的存储过程 执行多条动态语句的问题
- 如何在my.cnf里面设置binlog_format?
- 求教:FreeBSD下MySQL的安装配置问题
- linux下的c访问Windows下的mysql
- 请问各位高手:我现在用(JDBC版本3.08)连接MySQL(版本5.0.1)数据库怎么老是报告连接错误啊!急,在线等待???????
- postgres select now();问题
- 如何获取left join后,符合条件的有多少条
- mysql数据库备份 不用mysqldump
from
(
SELECT v.id,s.statuslevel
FROM
train t
LEFT JOIN video v on t.id = v.tid
LEFT JOIN videocharacter vc USING(fileid)
LEFT JOIN STATUS s USING(statusid)
) aa
group by aa.statuslevel