查询重复记录的SQL语句

select * from log as a ,(select message  from log  group by message having count(*)>1) bwhere 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 asselect traceuuid, tracetype, tracetime, tracecontentid, userid, userip, isfaile, departmentid, username, departmentnamefrom sys_operationtraceunionselect traceuuid, tracetype, tracetime, tracecontentid, userid, userip, isfaile, departmentid, username, departmentnamefrom sys_operationtrace_his;

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

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