SQL 语句集合

1. not 结果剔除

SELECT * FROM DM_GY_SWJG_JH WHERE NOT SWJGMC LIKE '%金华%';

2. 返回一个重复 N 次的字符串，返回结果 abcabcabcabc

SELECT REPLICATE('abc', 4) FROM DUAL;

3. 删除名称重复的数据

DELETE FROM H_DJ_NSRXX_1 A
 WHERE EXISTS (SELECT 1
          FROM H_DJ_NSRXX_1 B
         WHERE B.NSRMC = A.NSRMC
           AND B.ROWID > A.ROWID);