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查詢出來
uj5u.com熱心網友回復：
select aa.statuslevel,count(1) cntfrom
(
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
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/89499.html
標籤：MySQL
下一篇：workbench報錯