1
A表中的id,value;
B表中的id,value,name;现在要把A表中的value保存到B表中的name中
注:A表跟B表通过id可以关联,但是A表中的id不唯一
oracle中的解决办法:
UPDATE B SET name = (SELECT value FROM A WHERE B.id = A.id AND rownum=1 ORDER BY value ASC);
2
查看快照
select *
from 表 as of timestamp to_timestamp('2018-01-12 15:29:00', 'yyyy-mm-dd hh24:mi:ss')
3 加单引号 再列转行
select wm_concat(a) a from (select '''' || x.a || '''' as a from a_test x);
4
查重复出现的数据
select a.a, a.b, a.c, count(1)
from table想 a group by a.a, a.b, a.c,
select a.a, a.b, a.c
from table想 a group by a.a, a.b, a.c, having count(*) >1;