DB2 学习
文章平均质量分 58
xiaotuni
看电影,电视。
展开
-
刚学习Db2 对一条 select 语句得疑问.
insert into liaohaibing.Employee(ID,Name,Password,Department) select ID,Name,Password,Department from NULLID.Employee;不知道为什么这条句语还能执行成功.原创 2007-03-27 17:33:00 · 843 阅读 · 0 评论 -
Sale表中横列值转换成竖列显示。
SELECT EmployeeID, max(case SaleDate when 2007-01-01 then amount else null end) as jan, max(case SaleDate when 2007-02-01 then amount else null end) as feb, max(case SaleDate when 2007原创 2007-03-27 23:13:00 · 1246 阅读 · 0 评论 -
Reporting Function
SELECT ID,DepartmentID,Pay,SUM(PAY) Over(Partition BY DepartmentID)as Total,Pay*100/SUM(Pay) Over(Partition by DepartmentID) as "Pct of c2"FROM TempTableWHERE DepartmentID IN(15,20);SUM(PAY) Over(Pa原创 2007-04-02 00:01:00 · 758 阅读 · 0 评论 -
DB2 当中Rollup得用法,得一些看法。
select DEPARTMENT,Name,sum(amount) as sum,count(*) as count from sale inner join Employee on liaohaibing.EMPLOYEE.ID = liaohaibing.SALE.EMPLOYEEIDinner join liaohaibing.DEPARTMENT onliaohaibing.DEPA原创 2007-04-02 11:28:00 · 1996 阅读 · 0 评论 -
DB2 学习笔记宿主变量、游标、 Drop、Create、Alter、锁、性能维护。
宿主变量。exec sqlupdate t1set c1=:newvaluewhere c1 = :oldvalue;Exec sqlselect lastname,firstnameinto :last,:fistfrom t1where empon=:id;游标得定义________________Exec sql Declare c1 cursor for select c1,c2原创 2007-04-04 21:54:00 · 2253 阅读 · 0 评论