摘要:
1.使用ROWNUM伪列查询 1.1.查询十条数据(rownum<=n) SELECT ROWNUM,A.* FROM v_sjjx_unit_info A WHERE ROWNUM<=10 1.2.查询实体十条数据(between...and...) SELECT * FROM v_sjjx_xs 阅读全文
posted @ 2018-05-14 10:05
伏羲轩
阅读(4419)
评论(0)
推荐(0)
|
摘要:
1.使用ROWNUM伪列查询 1.1.查询十条数据(rownum<=n) SELECT ROWNUM,A.* FROM v_sjjx_unit_info A WHERE ROWNUM<=10 1.2.查询实体十条数据(between...and...) SELECT * FROM v_sjjx_xs 阅读全文
posted @ 2018-05-14 10:05
伏羲轩
阅读(4419)
评论(0)
推荐(0)
|