select a.*
from tab a join(
select [year],[month]=max([month]) from tab group by [year]
)b on a.[year]=b.[year] and a.[month]=b.[month]
from tab a join(
select [year],[month]=max([month]) from tab group by [year]
)b on a.[year]=b.[year] and a.[month]=b.[month]
from tab
group by year
having max( month )
“服务器: 消息 170,级别 15,状态 1,行 1
第 1 行: ')' 附近有语法错误。”
是什么原因啊???
group by year