select sum(X) as A,B,C from mytable order by A,group by B,C
select sum(X) as A,B,C from mytable order by B,C,group by A
我想问一下这条语句究竟该怎么写,第一句是我记得有这么一项,后一句是我大概记得,还有两句就是后面的ABC换位置。
select sum(X) as A,B,C from mytable order by B,C,group by A
我想问一下这条语句究竟该怎么写,第一句是我记得有这么一项,后一句是我大概记得,还有两句就是后面的ABC换位置。
基本都是这样,后面有的是order by B,C GROUP by A 之类的。反正考的就是order by 哪个,group by 哪个,前面的都一样:select sum(X) as A,B,C from mytable。
记住order by 语句一般放到最后