Oracle de-weight: a combination of other people's records

Oracle de-weight: Combined with other people's records, roughly the following two kinds of looks pleasing to the eye. 1.delete from Twhere   rowid No in   (select   min (rowid)   from   T   Group   by Go to the heavy field); For a chestnut:--To remove the delete from the Ptw_i_method_define_tempwhere ID not in   (select   min (id)   from   Ptw_i_method_define_temp   Group   by No); 2. (Note: Distinct is a record of exactly the same repetition.) The above is determined by whether the value of a column is repeated) insert into temporary table SELECT DISTINCT mobile from the original table, drop table original table, rename temporary table name to the original table name; Source: 
　　
Oracle de-weight: a combination of other people's records