```
select count(case when id>4 then id end),count(case when id=1 then id end ) from test;
```
```
select count(case when id>4 then id end),count(case when id=1 then id end ) from test;
```
本文标题：mysql根据count特定的值
本文链接：https://www.haomeiwen.com/subject/uhassctx.html
网友评论