SpringHASh的博客

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 ..

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.

SELECT *FROM ( SELECT rank() OVER (PARTITION BY b.C_EEGRPID ORDER BY b.EEKWH DESC) AS rank, b.METERNO, b.DISTRICTBCDID, b.ADDRESSID, b.CHANNELID , b.EEKWH, b.C_EEGRPID, b.C_EEGRPNAME FROM ( SELECT SUM(a.EEKWH) AS EEKWH, b.METERNO, a.DISTRICTBCDID, .

1.获取锁表的session id SELECT object_name, machine, s.sid, s.serial# ,o.ownerFROM gv$locked_object l, dba_objects o, gv$session s WHERE l.object_id　= o.object_id AND l.session_id = s.sid; 2.获取系统进程号 select distinct s.sid,s....

1.准备依赖与插件<build> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin>

1.字符串日期转date SELECT to_date(m.LASTCOM_TIME,'yyyy-MM-dd hh24:mi:ss') FROM DR_DEVICEINFO_SMARTSOCKET m2.date转字符串日期 SELECT to_char(m.CREATE_TIME,'yyyy-MM-dd hh24:mi:ss') FROM DR_DEVICEINFO_SMARTSOCKET m 3.获取当前毫秒值SELECT TO_NUMBER ( sysdate

查找和截取字符串使用substr()截取字符串格式：substr(String,start_location,length) 返回String的子字符串。 说明：String 原来的字符串 start_location 截取字符串的起始位置 length 可选参数，子字符串的长度 举例： substr(“ABCDEFG”, 0); //返回：ABCDEFG，截取所有字符 substr(“ABCDEFG”, 2); //返回：CDEFG，截取从C开始之后所有字符 substr(“ABCDE

1、常用的分组函数：AVG,SUM,MIN,MAX,COUNT,WM_CONCATAVG:平均值,SUM:最大值,MIN:最大值,MAX:最小值,COUNT:计算,WM_CONCAT:行转列select avg(sal),sum(sal) from emp;select max(sal),min(sal) from emp;select count(empno) from emp;select count(distinct depno) from emp;set linesize 200