表名:recordnotes
字段1:id 字段2:theme
例子:select row_number() over(order by id) as bj_id,theme from recordnotes where id between 6 and 10
解释:
id为主键
between 6 and 10 查询id在6-10之间的数据(包含6,和10)
查询出的结果会排序
表名:recordnotes
字段1:id 字段2:theme
例子:select row_number() over(order by id) as bj_id,theme from recordnotes where id between 6 and 10
解释:
id为主键
between 6 and 10 查询id在6-10之间的数据(包含6,和10)
查询出的结果会排序