merge into test a
using
(
select '1' as name, '女' as sex from dual
) b
on (a.name=b.name and a.sex = b.sex)
when not matched then
INSERT VALUES (1,'2','女');
查出重复值的SQL,如果有记录说明重复,没有则不重复。
select rowid,username,userpwd from a where a.rowid!=(select max(rowid) from a b where a.username=b.usernameand a.userpwd =b.userpwd );
[Quote=引用 1 楼 的回复:]
MERGE INTO tableA A
USING (筛选结果集) B
ON (A.XX=B.XX)
/*WHEN MATCHED THEN
UPDATE
SET LOW.KFRST = LOW1.KFRST */
WHEN NOT MATCHED THEN
INSERT
(FIELD1,..)
VALUES
(1,...);
……
[/Quote]
MERGE INTO tableA A
USING (筛选结果集) B
ON (A.XX=B.XX)
/*WHEN MATCHED THEN
UPDATE
SET LOW.KFRST = LOW1.KFRST */
WHEN NOT MATCHED THEN
INSERT
(FIELD1,..)
VALUES
(1,...);
你可以搜搜merge into 的yongf