select * from Building where id like '0002e54e762641278f4dc486fc67f335'
SELECT count(*) as ResidentCount FROM Resident r ,house h WHERE r.houseid = h.ID and h.buildingid = '0002e54e762641278f4dc486fc67f335'这2个查询语句可以合并成一句吗?
SELECT count(*) as ResidentCount FROM Resident r ,house h WHERE r.houseid = h.ID and h.buildingid = '0002e54e762641278f4dc486fc67f335'这2个查询语句可以合并成一句吗?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货