WITH t AS (
SELECT NTILE(10) OVER (order by id) AS PageNumber,ID FROM App
)
SELECT NTILE(10) OVER (order by id) AS PageNumber,ID FROM App
)
老是提示
')' 附近有语法错误。
确定是SQLSERVER005,网上有说WITH前面加分号;的,有的说开什么分隔符开关的,
整了半天,WITH语句后面是要跟语句的
WITH t AS (
SELECT NTILE(10) OVER (order by id) AS PageNumber,ID FROM App
)
SELECT NTILE(10) OVER (order by id) AS PageNumber,ID FROM App
)
SELECT * FROM t
这样就可以了,怎么说自己好呢!