Re: Rank with Total

[Ra Nala]

Hi Peter,

Thanks for your help.

Using below logic i am able to get rownumber , could you please help on rank_total(i.e. value as 3 should come) ?

in table i should not update, i should get rank_total using below query. Please\kindly help.

id | Name | rownumber rank_total
1 a 1 3
1 b 2 3
1 ads 3 3

SELECT
t.*,
@cur:= IF(id=@id, @cur+1, 1) AS RowNumber,
@id := id
FROM
t CROSS JOIN
(SELECT @id:=(SELECT MIN(id) FROM t), @cur:=0) AS init
ORDER BY
t.id