select * from
(
SELECT TOP 5 * FROM
(
SELECT TOP 5 * FROM Film ORDER BY AddTime DESC
)a
ORDER BY AddTime ASC
)b
ORDER BY AddTime DESC
(
SELECT TOP 5 * FROM
(
SELECT TOP 5 * FROM Film ORDER BY AddTime DESC
)a
ORDER BY AddTime ASC
)b
ORDER BY AddTime DESC
2.sql没有专门的分页处理语句,只能用类似上面的方法.
(
SELECT TOP 5 B.* FROM
(
SELECT TOP 5 * FROM Film ORDER BY AddTime DESC
) B
ORDER BY AddTime ASC --SQL查询分析器提示该行在关键字 'ORDER' 附近有语法错误。
) C
ORDER BY AddTime DESC
(
SELECT TOP 5 * FROM
(
SELECT TOP 5 * FROM Film ORDER BY AddTime DESC
) b --- 要定义一个表别名
ORDER BY AddTime ASC //SQL查询分析器提示该行在关键字 'ORDER' 附近有语法错误。