hety119的专栏

db2 => db2stop force DB20000I  DB2STOP命令成功完成。 db2 => db2start DB20000I  DB2START命令成功完成。 db2 => backup db sem to D:\myZone 备份成功。此备份映像的时间戳记是：20140718100400 ------------------------------------

select row_number() over() ,sem_dept.* from sem_dept ;

CREATE TABLE MY.TABLE  (AUTO_PK_ID  BIGINT  NOT NULL  GENERATED ALWAYS     AS IDENTITY (START WITH 1, INCREMENT BY 1, CACHE 20, NO CYCLE, NO ORDER)  )   DATA CAPTURE NONE;

oracle :select   * from  user where rownum db2 :select * from user fetch first 10 rows only; mysql:select * from user limit 10; sqlServer :select top 10 * from user ;