×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Jon Nickerson
Added: Sep 19, 2017 8:29 PM
Views: 3
Tags: no tags
  1. DELETE FROM cfaw_stu
  2.  WHERE ALTID IN (
  3.  SELECT
  4.  ALTID
  5. FROM
  6.    cfaw_stu a
  7. WHERE
  8.    rowid >
  9.      (SELECT MIN(rowid) FROM cfaw_stu b
  10.       WHERE
  11.          a.ALTID = b.ALTID
  12.       ));