数据库统计查询

最新推荐文章于 2023-05-17 08:50:45 发布

氵临渊羡鱼

最新推荐文章于 2023-05-17 08:50:45 发布

阅读量1.7k

点赞数 1

分类专栏：数据库文章标签：数据库数据

本文链接：https://blog.csdn.net/u012712261/article/details/76797629

版权

数据库专栏收录该内容

1 篇文章 0 订阅

订阅专栏

查询agentuid相同的数据并安装agentuid的数目进行排行

    select count(*) as total,agentuid from `ss_member` where agentuid>0 group by agentuid order by total desc limit 100 
  

根据id号查出其他字段的总额

    第一种 
  
    select uid,sum(money) as moneytotal,sum(votes) as votestotal  from cmf_users_cashrecord group by uid 
  
    第二种 
  
    select uid,sum(money) as moneytotal,sum(votes) as votestotal  from cmf_users_cashrecord where uid=100 
  
    第三种（说明 将familyid 和uid相同的用户 以天为单位 将profit进行统计） 
  
    select uid,sum(profit) as profitzong from cmf_family_profit where familyid=100 group by uid,time desc

统计不同值下的数量

   select sum(case when one_uid='10251' then 1 else 0 end) as one,sum(case when two_uid='10252' then 1 else 0 end) as two from xzb_users_agent 
 

查询两个字段在不同条件下差的和

    select 
  
    sum(case when bet_type=1 then coin else 0 end  - case when bet_type=1 then IFNULL(kick_conn,0) else 0 end) as one, 
  
    sum(case when bet_type=2 then coin else 0 end  - case when bet_type=2 then IFNULL(kick_conn,0) else 0 end) as two, 
  
    sum(case when bet_type=3 then coin else 0 end  - case when bet_type=3 then IFNULL(kick_conn,0) else 0 end) as three, 
  
    sum(case when bet_type=4 then coin else 0 end  - case when bet_type=4 then IFNULL(kick_conn,0) else 0 end) as four, 
  
    sum(case when bet_type=5 then coin else 0 end  - case when bet_type=5 then IFNULL(kick_conn,0) else 0 end) as five 
  
    from  cmf_users_game_bet 
  
    where  square_type=0