摘要: <!-- include 引用字段 --> <sql id="Base_Column_List"> D_RECID, D_USER_NAME, D_NAME, D_TYPE, ... </sql> <select id="select" resultMap="BaseResultMap" param 阅读全文
posted @ 2019-02-21 17:05 liw66 阅读(153) 评论(0) 推荐(0) 编辑
摘要: SELECT total.* FROM ( SELECT obj.uid, obj.score, CASE WHEN @rowtotal = obj.score THEN @rownum WHEN @rowtotal := obj.score THEN @rownum :=@rownum + 1 WHEN @rowtotal = 0 THEN ... 阅读全文
posted @ 2019-02-21 16:42 liw66 阅读(419) 评论(0) 推荐(0) 编辑