db2 sql急救

DKodak · July 19, 2019, 3:20am

db2 里面如何根据2个日期之间进行查询并分页

Jonny · July 19, 2019, 3:25am

select * from table dateCreated between 'xxxx-xx-xx' and 'xxxx-xx-xx' limit 10

DKodak · July 19, 2019, 4:18am

limit是MySQL的 db2用limit不行吧

Jonny · July 19, 2019, 4:31am

SELECT * FROM (Select 字段1,字段2,字段3,rownumber() over(ORDER BY 排序用的列名 ASC) AS rn from 表名) AS a1 WHERE a1.rn BETWEEN 10 AND 20

DKodak · July 19, 2019, 5:21am

查全部列的数据并还有是在2个日期之间的

12628192156 · July 19, 2019, 7:55am

（帖子被作者删除，如无标记将在 24 小时后自动删除）