本月博客排行
-
第1名
龙儿筝 -
第2名
lerf -
第3名
fantaxy025025 - johnsmith9th
- zysnba
- xiangjie88
年度博客排行
-
第1名
青否云后端云 -
第2名
宏天软件 -
第3名
gashero - wy_19921005
- vipbooks
- benladeng5225
- e_e
- wallimn
- javashop
- ranbuijj
- fantaxy025025
- jickcai
- gengyun12
- zw7534313
- qepwqnp
- 解宜然
- ssydxa219
- zysnba
- sichunli_030
- sam123456gz
- 龙儿筝
- arpenker
- tanling8334
- kaizi1992
- gaojingsong
- xpenxpen
- jh108020
- wiseboyloves
- ganxueyun
- xyuma
- xiangjie88
- wangchen.ily
- Jameslyy
- luxurioust
- lemonhandsome
- jbosscn
- mengjichen
- zxq_2017
- lzyfn123
- nychen2000
- forestqqqq
- wjianwei666
- ajinn
- zhanjia
- Xeden
- hanbaohong
- java-007
- 喧嚣求静
- kingwell.leng
- mwhgJava
最新文章列表
经典的Oracle分页
1、按rowid分页
select * from area where rowid in(select rid from (select rownum rn,rid from(select rowid rid,id fromarea order by id desc ) where rownum<82000) where rn>81980) order by id desc;
...
数据库sql分页
取出sql表中第31到40的记录(以自动增长ID为主键)
sql server方案1:
select
top 10 * from t where id not in (select top 30 id from t order by id ) orde by
id
sql server方案2:
select
top 10 * from t where id in ( ...
Oracle数据库中的分页语句
方式一:
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME) A
)
WHERE RN BETWEEN 3*(3-1)+1 AND 3*3
方式二分页查询格式:
SELECT * FROM
(
SELECT A.*, ROWNUM RN
FROM (SELECT * FROM TABLE_NAME ORDER ...
ch02 oracle基础二
本章任务
1:游标
--
DECLARE
CURSOR sales_cur IS SELECT * FROM EMP;
BEGIN
FOR sales_rec IN sales_cur LOOP
DBMS_OUTPUT.PUT_LINE('工资:'||sales_rec.empno);
END LOOP;
END;
/
2:存储过程与函数 ...