Oracle的分组排序功能实现最大值一列数据获取

    　　 select <include refid="ALL_COLUMNS"/>
        from (
            select <include refid="ALL_COLUMNS"/>, ROW_NUMBER() OVER (ORDER BY TOKEN_RATE DESC) AS rn
            from <include refid="TABLE_NAME"/>
            where TOKEN_RATE is not null
            and ts >= #{time.from}
            and ts < #{time.to}
        ) t
        WHERE t.rn = 1