- 博客(3)
- 收藏
- 关注
原创 db2递归查询
DB2:WITH temptab(deptid, deptname, superdept, level) AS ( SELECT root.deptid, root.deptname, root.superdept, 1 FROM departments root WHERE deptname=Samples & Co. UNION AL
2006-11-18 11:40:00 1389
原创 db2与表相关的存储过程查询
select PROCNAME from SYSCAT.PROCEDURES where SPECIFICNAME in(select dname from sysibm.sysdependencies where bname in ( select PKGNAME from syscat.packagedep where bname=W_XT_YH))
2006-11-17 13:54:00 4928
原创 db2分页查询
SELECT * FROM (Select IID,IWZID,rownumber() over() AS rn from TEST) AS a1 WHERE a1.rn BETWEEN 0 AND 10
2006-11-17 13:52:00 1447
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人