ランクや行カウントを作成する

Select

a.*

,@rank:= @rank + 1 AS `Rank`

FROM your_dataset a

,(SELECT @rank:=0) b

SELECT

a.`Name`,

a.`Amount`,

CASE WHEN a.`Name` = @PriorRecordName then @RowNumber:= @RowNumber + 1

WHEN a.`Name` <> @PriorRecordName then @RowNumber:= 1

END AS 'Windowed Row Number',

@PriorRecordName:= a.`Name`

FROM `mydatatable` a, (SELECT @PriorRecordName:= '', @RowNumber:= 0) AS b

ORDER BY a.`Name, a.`Amount

Select

  a.*

  ,@rank:=  IF(@prev = a.`column`,@rank + 1,1) AS `Rank`

  ,@prev:= a.`column`

ROW_NUMBER () OVER

([ PARTITION BY expr_list ]

[ ORDER BY order_list ]

)