Automated sequential number or row number for MySQL view

Question

I created a MySQL view using group by and order by options for table. For that I need sequential number for each row. In detail, I group the records by invoice number and order the records by created time. For these I need sequential numbers for each row.

Answer 1

You can not create such a column in a view. You will need a stored procedure for this.

https://forums.mysql.com/read.php?101,259575,259575

Answer 2

My requirements is I uploaded the products with invoice number and created time. I need to group invoice number and order by created time. For each invoice I need to raise the sequential numbers according to date. Is there any alternative option if there is no option directly?