发现书中有条sql是这么写的:
select rate,count(*) from login_modular group by rate order by 2 desc;
这里排序时用到的order by 2; 之前一直没这么用过于是上网查了下。这句话的意思和下面的sql等同:
select rate,count(*) as countNum where login_modular group by rate order by countNum desc;
意思是以第几个column排序。如果上面的sql使用order by 1 那么将以rate进行排序。