order by 与group by 的并发使用问题

jinhua!@#

各位大侠： 我有个基础的问题，就是order by 和 group by 能够共同使用吗
？比如下面的sql ,他总是报一版性错误，请各位帮帮忙吧！

select customerid,max(premuim) as premuim_1,
  min(amount) as amount_1 from customer_sum_fact
where premuim order by premuim desc
group by customerid ,premuim

sunnyfun

把 where premuim 去了再试试

jinhua!@#

去了，还是不行，还是宝一样的错误
Error: General error.Syntax error (State:37000, Native Code: FFFFD4CC)

sunnyfun

还不止一个错哦，再把 order by premuim desc 放到最后

jinhua!@#

新的错误来了：
Error: Unspecified System Error =  -19828. (State:S1000, Native Code: FFFFB28C)
我真是搞不懂了，这两个可以同时应用在一个sql中是吗？没有 问题吧？

sunnyfun

你确定用的是mysql吗

showsa

貌似不是mysql

先 group by 然后再 order by 吧

zhangshebao

select customerid,max(premuim) as premuim_1,
  min(amount) as amount_1 from customer_sum_fact
group by customerid
order by max(premuim) desc