zhemejinnameyuan's recent timeline updates zhemejinnameyuan's recent timeline updates |
zhemejinnameyuanV2EX member #514697, joined on 2020-10-26 21:06:27 +08:00 |
zhemejinnameyuan's recent replies
Jul 25, 2022 Replied to a topic by sunmoon1983 › MySQL › 求大神解答，这种 sql 应该怎么写？ |
可以用 case when 试试,条件自己根据情况修改下
```
SELECT
count(case when (age>1 and code in ('P00','P01','P96')) then 1 else null end) as '条件 1',
count(case when (age<5 and code in ('I05','I06','I09')) then 1 else null end) as '条件 2'
FROM
table_name
```
```
SELECT
count(case when (age>1 and code in ('P00','P01','P96')) then 1 else null end) as '条件 1',
count(case when (age<5 and code in ('I05','I06','I09')) then 1 else null end) as '条件 2'
FROM
table_name
```
Jul 24, 2022 Replied to a topic by defunct9 › 旅行 › 8 月 10 日到 8 月 30 日新疆游 |
@nexklee 朋友托我问问
Jul 17, 2022 Replied to a topic by Rubbishsite › 分享创造 › 速速 V 我 50 |
找个好点的域名,如:https://qiong.bi/
Mar 16, 2021 Replied to a topic by baibaibaibai › 问与答 › 问一下大家，结婚都需要提前准备什么，第一次 |
至少要准备一个对象 😄
Jan 5, 2021 Replied to a topic by 6954321789 › 投资 › 看各位老哥都在晒收益，想入个门 |
喝酒吃肉
Nov 20, 2020 Replied to a topic by crystal1992 › 重庆 › 超想去重庆定居，有没有重庆的小伙伴来说说重庆互联网到底有多荒漠 |
@Ansen 重庆互联网薪资 相比成都 差不多要少 1k-2k 左右
Nov 3, 2020 Replied to a topic by 79lawyer › 问与答 › 办公室每天喝纯净水太寡淡了，求推荐口粮茶叶改改口味 |
信阳毛尖茶
Select Language