请大家看一眼是哪有错误，字段名和表名是没错的。

Question

select storeid,row_number() over(partition by storeid order by insertdate desc) row1 from risk_store_score

报错：You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(partition by storeid order by insertdate desc) row1 from risk_store_score' at line 1

我个人怀疑是不是MySQL版本的原因

Answer 1

是的
你这个应该是5.几的版本
mysql8.几才支持窗口函数