rank 排行别名映射

微辣米粉

于 2017-06-22 18:35:05 发布

阅读量731

点赞数

分类专栏：【数据库】文章标签： sql mybatis

本文链接：https://blog.csdn.net/tuntun1120/article/details/73610113

版权

【数据库】专栏收录该内容

23 篇文章 1 订阅

订阅专栏

如果有下划线的一定要注意用别名！

<select id="queryWithPage"  resultType="com.xxx.UserAccQo" >

  SELECT EXP as exp,
  GOLD_COIN as goldCoin,
  USER_ID as accountUserId,
  USER_ID as userId,
   @rank:=@rank +1 AS rank

  FROM

  (SELECT EXP,GOLD_COIN,USER_ID as ACCOUNT_USER_ID, USER_ID,SEX,NICK_NAME,MOBILE,HONOR_NAME,CREATE_TIME FROM
              (
                  (SELECT EXP,GOLD_COIN,USER_ID as ACCOUNT_USER_ID FROM ACCOUNT ORDER BY EXP DESC)a,
                  (SELECT USER_ID FROM `USER`)u
              )
              WHERE
              a.ACCOUNT_USER_ID = u.USER_ID
  ) usr_acc,

  (SELECT @rank:=0)r;


</select>