Clickhouse, how to add row number column?

Question

SQL

SELECT phone_normalize as phone, toStartOfMonth(date) as created FROM table ORDER BY phone_normalize, created Tell me
how to add a column with line numbers so that phone groups are taken into account.
See screenshot take.ms/PVQsN

Answer 1

there is no such function in the current version of clickhouse

Answer 2

ROW_NUMBER()
https://msdn.microsoft.com/en-us/library/ms189461.aspx