帮我看这个sql语句

[快乐无边]

服务器: 消息 156，级别 15，状态 1，行 1
在关键字 'group' 附近有语法错误。

select f_year from t_kejianol where f_k_lessonid='02047' order by f_year asc group by f_year

[快乐无边]

知道了
两个换个位置就好了.

select f_year from t_kejianol where f_k_lessonid='02047' order by f_year asc group by f_year

[sdhdy]

select f_year from t_kejianol where f_k_lessonid='02047' group by f_year order by f_year asc 

[sdhdy]

[Quote=引用 1 楼 ajaxchen_615 的回复:]
知道了
两个换个位置就好了.

select f_year from t_kejianol where f_k_lessonid='02047' order by f_year asc group by f_year
[/Quote]

对，先GOUUP BY 再 order by

[ws_hgo]

先分组
在排序

[ws_hgo]

select f_year from t_kejianol where f_k_lessonid='02047' group by f_year
order by f_year asc 

[dyeerp]

select f_year
from t_kejianol
where f_k_lessonid='02047'
group by f_year
order by f_year asc

[JonasFeng]

group by 和 order by 换个位置就OK了