网站首页 站内搜索

搜索结果

查询Tags标签: cidnum1,共有 1条记录
  • mysql 按某字段分组分箱聚合查询

    SELECT cidnum1,count(*) as num from ( SELECT DISTINCT id,cidnum, (CASE WHEN 0<cidnum and cidnum<=1 THEN 1个公司WHEN 1<cidnum and cidnum<=5 THEN 2-5个公司WHEN 5<cidnum and cidnum<=10 THEN 6-10个公司when 10<cidnum and cidnum<=50…

    2021/5/7 19:31:23 人评论 次浏览
扫一扫关注最新编程教程