order by 與group by 的并發(fā)使用問題

jinhua!@#

各位大俠： 我有個(gè)基礎(chǔ)的問題，就是order by 和 group by 能夠共同使用嗎
？比如下面的sql ,他總是報(bào)一版性錯(cuò)誤，請各位幫幫忙吧！

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!@#

去了，還是不行，還是寶一樣的錯(cuò)誤
Error: General error.Syntax error (State:37000, Native Code: FFFFD4CC)

sunnyfun

還不止一個(gè)錯(cuò)哦，再把 order by premuim desc 放到最后

jinhua!@#

新的錯(cuò)誤來了：
Error: Unspecified System Error =  -19828. (State:S1000, Native Code: FFFFB28C)
我真是搞不懂了，這兩個(gè)可以同時(shí)應(yīng)用在一個(gè)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