数据库
superjr1
这个作者很懒,什么都没留下…
展开
-
oracle 根据字段分组排序 取其第一条数据
以某个字段分组 取其第一条数据select * from (select t.app_id, t.emp_no, t.device_id, t.device_type, t.last_connect_time, t.device_model, rank() over(partition by t.device_type or原创 2021-04-29 16:48:36 · 1830 阅读 · 0 评论 -
Oracle 存在修改,不存在插入
merge into T_WXOPENINFO t1 USING (select #{userId} AS a, #{appId} AS b from dual) t2 on (t1.userId = t2.a and t1.appid = t2.b) when matched then update set t1.openId = #{openId} when no原创 2021-04-29 16:34:44 · 170 阅读 · 0 评论 -
oracle 拆分存储过程(双分隔符拆分)
自定义字符拆分存储过程(双分隔符拆分)CREATE OR REPLACE PROCEDURE GET_SUB_STR(V_NAMES IN VARCHAR2, V_SPLIT IN VARCHAR2, V_CHILD_SPLIT IN VARCHAR2) IS V_NUM NUMBER; V_NO VARC原创 2021-04-29 16:32:39 · 453 阅读 · 0 评论 -
oracle 分页查询
oracle 分页查询SELECT * FROM (SELECT tt.*, ROWNUM AS rowno FROM ( SELECT t.* FROM table_name t WHERE apply_date BETWEEN TO_DATE ('20210429', 'yyyymmdd') AND TO_DAT原创 2021-04-29 16:28:20 · 49 阅读 · 0 评论