Re: Rank with Total

[Ra Nala]

Hi Peter Sir,

actually ,We are using many tables to get data so kindly check below query and if you are able to help on below 4th (rank_total) column (i.e. value= 3 should be for 3 rows based on rank order 1,2,3 then help me.

kindly ignore if it is not relevant for you.

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

Data as like below

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

Thank you