I have a table which has 3 fields, I want rank column based on user_id and game_id.Here is SQL Fiddle : http://sqlfiddle.com/#!9/883e9d/1