05 2021 档案

hive 生成随机数 唯一标识 唯一ID
摘要：select concat(unix_timestamp(),cast(rand() * 100000000 as int)) 阅读全文
posted @ 2021-05-26 11:46 cup_leo 阅读(2090) 评论(0) 推荐(0)
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个公 阅读全文
posted @ 2021-05-07 07:41 cup_leo 阅读(601) 评论(0) 推荐(0)