查询重复记录的SQL语句

select * 
from log as a ,(select message  from log  group by message having count(*)>1) b
where a.message =b.message 

update sys_point t set t.location = 
(select s.location  from atmsqhd.sys_point s where t.pointcode = s.pointcode) 
where exists 
(select 1 from atmsqhd.sys_point s where s.pointcode = t.pointcode )

create or replace view view_operate as
select traceuuid, tracetype, tracetime, tracecontentid, userid, userip, isfaile, departmentid, username, departmentname
from sys_operationtrace
union
select traceuuid, tracetype, tracetime, tracecontentid, userid, userip, isfaile, departmentid, username, departmentname
from sys_operationtrace_his;

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

http://it.oyksoft.com/post/641/