Mysql实现排序

排序

SELECT

    obj.user_id,obj.score,@rownum := @rownum + 1 AS rownum

FROM

    (

        SELECT

            user_id,

            score

        FROM

            `sql_rank`

        ORDER BY

            score DESC

    ) AS obj,

    (SELECT @rownum := 0) r

 

 

 

有重复

SELECT

    obj.user_id,

    obj.score,

    CASE

WHEN @rowtotal = obj.score THEN

    @rownum

WHEN @rowtotal := obj.score THEN

    @rownum :=@rownum + 1

WHEN @rowtotal = 0 THEN

    @rownum :=@rownum + 1END AS rownum

FROM

    (

        SELECT

            user_id,

            score

        FROM

            `sql_rank`

        ORDER BY

            score DESC

    ) AS obj,

    (SELECT @rownum := 0 ,@rowtotal := NULL) r

C# 运行上面程序时会异常   需要   dbconfig + ";Allow User Variables=True;" 进行处理