Oracle
ekinguofeng
这个作者很懒,什么都没留下…
展开
-
Oracle中取前N条记录的方法
/*取emp表中物理记录rownum小于10的记录*/SELECT *FROM ( SELECT rownum id,ename,sal FROM emp)WHERE id //*按ename排序后取前10条记录*/SELECT rownum,ename,salFROM ( SELECT ename,sal FROM emp order by ename asc)WHERE row原创 2008-11-25 15:45:00 · 686 阅读 · 0 评论 -
使用Update更新A表中存在于B表中的记录
ORACLE和DB2写法如下所示:UPDATE table1 a SET (a.f1,a.f2,a.f3) = (SELECT b.f1,b.f2,b.f2 FROM table2 b WHERE keyid = a.keyid)WHERE a.keyid IN (SELECT b.keyid FROM table2 b WHERE keyid = a.keyid)MS SQL Server写原创 2009-05-27 10:16:00 · 505 阅读 · 0 评论 -
Oracle分页显示的N种方法
/*创建测试数据*/CREATE SEQUENCE seq_test_tableMINVALUE 1MAXVALUE 1000000INCREMENT BY 1START WITH 1CACHE 10; CREATE TABLE test_table(id number primary key,name VARCHAR2(100),note VARCHAR2(200)); DECL原创 2009-05-27 10:20:00 · 264 阅读 · 0 评论