| 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 Server 2008行数据和页数据的一些处理方法，希望能对DBA的管...
本文主要是如何修改天融信NGFW4000防火墙用户认证数据库对象的介绍。...本类热点
；QQ联络：1360095750。