| 单号 | 付款方式 |
|---|---|
| 1 | 人民币 |
| 1 | 微信支付 |
| 2 | 支付宝 |
| 2 | 挂账 |
| 3 | 人民币 |
| 3 | 挂账 |
| 4 | 人民币 |
| 4 | 支付宝 |
| 4 | 微信支付 |
| 5 | 人民币 |
| 6 | 微信支付 |
| 7 | 支付宝 |
| 满足的结果：单号 1,4,5,6,7，请问查询语句如何编写？ |
select * from ( SELECT billid,COUNT(*) AS total_count, COUNT(CASE WHEN PAYDESC in ('人民币','支付宝','微信') THEN 1 ELSE NULL END) AS satisfied_count FROM BILL_PAYWAY group by BILLID) as v where v.satisfied_count=v.total_count order by v.BILLID desc
select 单号 from table where 付款方式 in (人民币，支付宝，微信) group by 付款方式 having count(DISTINCT 单号) = 3
select * from ( SELECT billid,COUNT(*) AS total_count, COUNT(CASE WHEN PAYDESC in ('人民币','支付宝','微信') THEN 1 ELSE NULL END) AS satisfied_count FROM BILL_PAYWAY group by BILLID) as v where v.satisfied_count=v.total_count order by v.BILLID desc
请登录
关于 LearnKu
粤公网安备 44030502004330号
推荐文章：