Group by 1 Order by 1到底是什么

Group by 1 Order by 1

碰到了个前朝的SQL写法，之前没用过所以探究一下，先说结论：
就是第一个字段的意思，但是这个1是select 后跟的列的第一个，并不是表中的第一列。
验证(各位有数据库的顺手跑一下就很清楚了)：

SELECT * FROM `sc` group by SId;
SELECT * FROM `sc` group by CId;
SELECT * FROM `sc` group by score;
SELECT * FROM `sc` group by 1;
SELECT * FROM `sc` group by 2;
SELECT * FROM `sc` group by 3;
select CId,score from sc group by 1;

总结(结省时间)：
结果1=结果4
结果2=结果5=结果7
结果3=结果6
结论：group by x ，指的是根据 select 后的第 x 项进行 group by