大家好,又见面了,我是你们的朋友全栈君。
SET @row_number = 0;
SELECT (@row_number:=@row_number + 1) AS num, firstName, lastName FROM employees LIMIT 5;
set @row_number := 1;
SELECT @row_number := CASE WHEN @customer_last = customerNumber THEN @row_number + 1 ELSE 1 END AS num, @customer_last := customerNumber as CustomerNumber, paymentDate, amount FROM payments ORDER BY customerNumber;
发布者:全栈程序员栈长,转载请注明出处:https://javaforall.cn/132383.html原文链接:https://javaforall.cn