select b.account,b.real_name,sum(case when (length(content)<= 140) then 1
when (length(content)<= 274) then 2
when (length(content)<= 408) then 3
when (length(content)<= 542) then 4
when (length(content)<= 676) then 5
when (length(content)<= 810) then 6
when (length(content)<= 944) then 7 end) from tab_sms_send a inner join tab_user_info b on a.sender=b.user_id where b.real_name = '冯鹏' or account = 'fengpeng' or user_id = 362
统计sql语句
最新推荐文章于 2023-08-26 16:16:04 发布