PJF1501105594的博客

select a.*from(select t1.*,(select count(*)+1 from 表 where 分组字段=t1.分组字段 and 排序字段<t1.排序字段) as group_idfrom 表 t1) awhere a.group_id<=3 # 假设取前3条

SELECT * FROM A tb inner join (select bracelet_id,max(created_time) as maxTime from A GROUP BY bracelet_id) maxtimeon tb.bracelet_id = maxtime.bracelet_id and maxtime.maxTime = tb.created_time

useAffectedRows=true&useUnicode=true&characterEncoding=UTF-8useAffectedRows=true 作用使用受影响的行的数量进行返回 例如update 返回修改的数量useUnicode=true&characterEncoding=UTF-8 写入数据乱码使用

java -cp druid-1.1.14.jar com.alibaba.druid.filter.config.ConfigTools my_password将得到：privateKey:************publicKey:************password:************配置文件中：password:passworddruid: filter: config: enabled: true connection-properties: co

select case when A>0 then A else null end as A1 ,case when A<0 then A else null end as A2from 表名实例：select info.vehicle_no,info.work_area,ttype."name",tinfo.sim_no,tinfo.terminal_type,--tinfo.terminal_no case when tinfo.termin...

<insert id="insertRoleGetId" parameterType="com.entity.RoleEntity"> <selectKey keyProperty='obj.roleId' resultType='string' order='AFTER'> select role_id from t_role where role_nam...

<insert id="uploadList" parameterType="com.bean.FgUrgencyShipmentList"> INSERT INTO tableName (PRODUCT,TYPE,HHAPN,URGENCY,STORAGE) <foreach collection="list" item="var" index="index" separ...

創建表空間CREATE TABLESPACE tableNameLOGGINGDATAFILE 'D:\OracleDatabaseFile\tableName.dbf' SIZE 10M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITEDEXTENT MANAGEMENT LOCAL創建用戶CREATE USER username IDENTIFI...

and write_time between (select trunc(sysdate,'mm') from dual) and sysdate

第一步：建立备份脚本oraclebackup.bat首先建立一个备份bat文件，在D盘下新建备份目录oraclebackup，将oracle安装目录下的EXP.EXE复制到此目录下，再新建一个文本文件oraclebackup.txt，内容如下：@echo offecho 删除10天前的备分文件和日志forfiles /p "D:\oraclebackup" /m *.dmp...