![](https://img-blog.csdnimg.cn/20190918140158853.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
SQL
SQL
宁漂打工仔
蜗牛角上争何事 石火光中寄此身
展开
-
mysql删除出现次数大于1的数据
【代码】mysql删除出现次数大于1的数据。原创 2022-09-21 16:23:36 · 489 阅读 · 0 评论 -
oracle insert into select写法
INSERT INTO T_MONITOR_USER_INFO (METER_NO,CONSUMER_NO,USER_INFO,COURT_ID)select * from(select distinctMETER_NO,CONSUMER_NO,'wy' as USER_INFO,EPU_COURT as COURT_ID from T_METER where C_DISTRICTBCDID in (select DISTINCTDISTRICTBCDIDfrom ..原创 2021-09-17 15:10:49 · 18582 阅读 · 0 评论 -
ORACLE navicate to_date()
select *from U_WORK_ORDER_QUESTIONWHERE 1=1AND CREATE_TIME >= to_date('2021-08-19 01:57:58', 'yyyy-mm-dd hh24:mi:ss') AND CREATE_TIME <= to_date('2021-08-19 14:57:58', 'yyyy-mm-dd hh24:mi:ss')原创 2021-08-19 10:50:51 · 464 阅读 · 0 评论 -
navicate oracle 过滤时间最大的一条数据
SELECTDISTRICTBCDID,ADDRESSID,CHANNELID,max(EECLOSETIME)FROM "T_ELECBICYCLE_ARC" WHERE 1=1 and RECORDDATE = 210609and EECLOSETIME >= to_date('2021-06-10 15:01:59','yyyy-MM-dd hh24:mi:ss')GROUP BYDISTRICTBCDID,ADDRESSID,CHANNELIDORDER BY.原创 2021-06-09 17:51:33 · 278 阅读 · 0 评论 -
oracle 将截取指定位数字符串,并且仅替换0开头的字符串
源字符串304700200030470002003047011200SELECT SUBSTR(DEVICE_NO,1,4) as DISTRICT_ID,REGEXP_REPLACE(SUBSTR(DEVICE_NO,5,4),'^0+','') as ADDRESS_ID,PHASE,EE_KWH,RECORD_DATE,SEGMENT_IDFROM T_MEASURE_RECORD原创 2021-04-26 11:58:59 · 531 阅读 · 0 评论 -
SSM Mybatis在设置排序后PageHelper分页插件分页第5页开始失效的问题
场景 一个简单的页面查询(后台用mvc+mybatis),page.html——>Controller——>Service(PageHelper ——>调用Dao查询)——>Dao(sql语句写在mybatis的DaoClassNameMapper.xml中)——>DataSourse。问题发现及过程1.业务说这个页面排序,所以我首先直接在mybatis的DaoClassNameMapping.xml中的查询加了一句:"order by排序字段desc",结果...转载 2021-01-27 15:14:27 · 324 阅读 · 0 评论 -
数据库关键字深入理解
1.EXIST使用参考 :https://blog.csdn.net/wqc19920906/article/details/798003742.having使用参考 :https://blog.csdn.net/u013182960/article/details/80819505原创 2020-10-09 15:50:20 · 296 阅读 · 0 评论 -
mysql批量插入数据2000条只要289ms
1.创建表DROP TABLE IF EXISTS user;CREATE TABLE user( id BIGINT(20) NOT NULL COMMENT '主键ID', name VARCHAR(30) NULL DEFAULT NULL COMMENT '姓名', age INT(11) NULL DEFAULT NULL COMMENT '年龄', email VARCHAR(50) NULL DEFAULT NULL COMMENT '邮箱', PRIMARY KEY (原创 2020-09-30 15:42:36 · 1630 阅读 · 0 评论 -
oracle 算 前7天 按每一天 每一类 分类电器从高到低排名
select rank() over (partition by b.C_EEGRPID,RECORDDATE order by b.EEKWH desc) as rank,b.METERNO,b.EEKWH,b.C_EEGRPID,b.C_EEGRPNAME,b.RECORDDATEfrom ( select sum(a.EEKWH) as EEKWH, d.METERNO, c.C_EEGRPID, g.C_EEGRPNAME, a.RECORDDATE ..原创 2020-08-25 10:37:09 · 125 阅读 · 0 评论 -
oracle查看是否锁表语句
select p.spid,c.object_name,b.session_id,b.oracle_username,b.os_user_name,s.SQL_FULLTEXT, a.MACHINE,a.CLIENT_INFO,a.OSUSER from v$process p, v$session a, v$locked_object b, v$sql s, all_objects c where p.addr=a.paddr and a.pr...原创 2020-08-24 16:30:31 · 228 阅读 · 0 评论 -
oracle使用mybatis操作批量插入、更新数据
异常堆栈org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: java.sql.SQLException: ORA-06550: 第 22 行, 第 13 列: PL/SQL: ORA-00933: SQL 命令未正确结束ORA-06550: 第 3 行, 第 13 列...原创 2020-03-19 20:37:16 · 1186 阅读 · 0 评论 -
logback 自动自动插入数据到 oracle 的三张建表语句
DROP TABLE logging_event_property;DROP TABLE logging_event_exception;DROP TABLE logging_event;CREATE TABLE logging_event ( timestmp BIGINT NOT NULL, formatted_message VARC...原创 2020-03-07 15:47:09 · 345 阅读 · 0 评论 -
union all 出现 > ORA-01789: query block has incorrect number of result columns
SELECT a.METERBOXID AS row_id, a.epu_name, a.epu_local,b.EPU_PROVINCE,b.epu_city, b.epu_district, b.epu_court , b.SUBSTAINID as SUBSTAIN_ID ,b.OUTGOINGCABINETID,b.branchboxid,b.METERBOXID, b.mete...原创 2020-03-07 11:27:16 · 551 阅读 · 0 评论