发布网友 发布时间:2022-04-23 02:41
共1个回答
热心网友 时间:2022-04-09 02:05
这个很简单,按照获取时间排序即可。
SELECT *
FROM (SELECT xzqmc, ROW_NUMBER() OVER (ORDER BY getdate()) AS rowNum
FROM dic_xzdm) mytable
WHERE rowNum BETWEEN 10 AND 20
--------------------------------
如果有自增主键那比用getdate强!