摘要: COUNT((('字段名' = '条件') OR NULL)) -- 列子如下 在IP段列表显示下面IP总数量,空闲数量,故障数量 SELECT A.*,COUNT(B.id) AS totalip,COUNT(((B.use_status = 1) OR NULL)) AS idleip,COUN 阅读全文
posted @ 2020-10-27 17:56 $Elvin 阅读(2214) 评论(0) 推荐(0)