执行顺序:from... where...group by... having.... select ... order by...
转: http://blog.csdn.net/liubo2012/article/details/8209324