MySQL implementation sequencing

Sort

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

There are duplicates

SELECT

OBJ.USER_ID,

Obj.score,

Case

When @rowtotal = Obj.score Then

@rownum

When @rowtotal: = Obj.score Then

@rownum: [Email protected] + 1

When @rowtotal = 0 Then

@rownum: [email protected] + 1END as RowNum

From

(

SELECT

USER_ID,

Score

From

' Sql_rank '

ORDER by

Score DESC

) as obj,

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

C # Run the above program will be abnormal need dbconfig + "; Allow User variables=true; "To process

MySQL implementation sequencing