Rank() over Partition by in mysql
Try this query: – MySql does not support Rank() function. select result.id,result.login,result.rank from ( SELECT id, login, IF(login=@last,@curRank:=@curRank,@curRank:=@_sequence) AS rank, @_sequence:=@_sequence+1, @last:=login FROM ds , (SELECT @curRank := 1, @_sequence:=1, @last:=0) r ORDER BY id asc) as result; Hope it helps you!