当前位置：网站首页>ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions unless TOP, OFFSET, or FOR XML is also specified

ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions unless TOP, OFFSET, or FOR XML is also specified

2022-08-09 15:35:00 【Warmer °】

Type 1

Modify configuration file pagehelper.helper-dialect=sqlserver2012

<select id ="test" resultType="User">select * from t_user order by userId</select><select id ="test_COUNT" resultType="Long">select count(0) from t_user</select>

The second

TOP 100 PERCENT

Third

OFFSET 10 ROWS
原网站

版权声明
本文为[Warmer °]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/221/202208091410537432.html

边栏推荐

猜你喜欢

随机推荐