SET @row_number = 0; SELECT (@row_number:=@row_number + 1) AS num, firstName, lastName FROM employees ORDER BY firstName, lastName LIMIT 5;
SELECT row_number() over ( order by firstName) RowNumberSqeuence,FirstName from rowNumberDemo order by FirstName;
set @row_number := 0; SELECT @row_number:=CASE WHEN @customer_no = customerNumber THEN @row_number + 1 ELSE 1 END AS num, @customer_no:=customerNumber customerNumber, paymentDate, amount FROM payments ORDER BY customerNumber;