| SELECT T1.city,
(select count(*) from T2 where T1.id=T2.id )
as totbooks ,
(select count(*) from T3 where T1.id=T3.id
and descr like '%newspaper%' )
as totnewspaper
FROM T1 group by T1.description |
| SELECT T1.city,
(select count(*) from T2 where T1.id=T2.id )
as totbooks ,
(select count(*) from T3 where T1.id=T3.id
and descr like '%newspaper%' )
as totnewspaper
FROM T1 group by T1.description |
熱詞搜索：
上一篇：SQL查詢一年中的所有星期五
下一篇：如何從SQL表中刪除數(shù)據(jù)
收藏
Copyright © 2009-2022 網(wǎng)絡安全和運維網(wǎng) All rights reserved. 京ICP備10047140號 京公安網(wǎng)備11010802014307
掃碼關注微信
