ITPub博客

select empnum, dept, salary, rank()       over (partition by dept order by salary desc nulls last) as rank, dense_rank() over (partition by dept order by salary desc null...

从今天开始在网上写点以及转载一些数据库相关的东西

db2 list tablespaces show detaildb2pd -tablespaces 5 group -db dbnSELECT '0' AS PART ,CHAR(TABLESPACE_NAME,25) AS TABLESPACE_NAME, TABLESPACE_ID, TOTAL_PAGES,USABLE_PAGES,USED_PAGES, FREE_PAGES,PAGE...