Answered by : sore-serval-4js4gy10a3rc

SET @row_number = 0;
SELECT (@row_number:=@row_number + 1) AS num, firstName, lastName
FROM employees

Source : https://www.mysqltutorial.org/mysql-row_number/ | Last Update : Mon, 27 Sep 21