sql
earthhour
这个作者很懒,什么都没留下…
展开
-
mysql按日统计,去重后汇总
select date_format(t.login_date,'%Y-%m-%d') AS 日期,COUNT(DISTINCT t.user_id) as 人数from user_login tgroup by date_format(t.login_date,'%Y-%m-%d') ORDER BY t.login_date ASC;统计系统每天登录人数,去除重复登录原创 2020-11-17 15:26:35 · 2457 阅读 · 0 评论 -
oracle sql 记录存在则更新,不存在则插入
MERGE INTO USING ON ()WHEN MATCHED THEN DELETE WHEN NOT MATCHED THEN [LOG ERRORS ]; MERGE INTO table aUSING ( SELECT '1' as name FROM dual ) bON (a.name = b.name)WHEN MATC原创 2013-07-21 17:44:13 · 4591 阅读 · 0 评论 -
有用的sql语句
update DISTRICT set DISTRICT_NAME = replace(DISTRICT_NAME,'-','')替换DISTRICT_NAME字段数据中的中横线“-”原创 2013-11-11 17:22:29 · 640 阅读 · 0 评论