本月博客排行
-
第1名
Xeden -
第2名
fantaxy025025 -
第3名
bosschen - paulwong
- johnsmith9th
年度博客排行
-
第1名
青否云后端云 -
第2名
宏天软件 -
第3名
gashero - gengyun12
- wy_19921005
- vipbooks
- e_e
- benladeng5225
- wallimn
- ranbuijj
- javashop
- jickcai
- fantaxy025025
- zw7534313
- qepwqnp
- robotmen
- 解宜然
- ssydxa219
- sam123456gz
- zysnba
- sichunli_030
- tanling8334
- arpenker
- gaojingsong
- xpenxpen
- kaizi1992
- wiseboyloves
- jh108020
- xyuma
- ganxueyun
- wangchen.ily
- xiangjie88
- Jameslyy
- luxurioust
- mengjichen
- lemonhandsome
- jbosscn
- nychen2000
- zxq_2017
- lzyfn123
- wjianwei666
- forestqqqq
- ajinn
- siemens800
- hanbaohong
- 狂盗一枝梅
- java-007
- zhanjia
- 喧嚣求静
- Xeden
最新文章列表
经典的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:存储过程与函数 ...