排除重复数据（保留最早的记录）

  1. SELECT
  2. * 
  3. FROM
  4. {table_name} 
  5. WHERE
  6. id NOT IN (
  7.   SELECT
  8.   min_id 
  9.   FROM
  10.   ( SELECT min( id ) AS min_id, count( id ) AS c FROM {table_name} GROUP BY {distinct_field} ) tmp_exclude_{table_name} 
  11. );

排除重复数据（保留最后的记录）

  1. SELECT
  2. * 
  3. FROM
  4. {table_name} 
  5. WHERE
  6. id NOT IN (
  7.   SELECT
  8.   max_id 
  9.   FROM
  10.   ( SELECT max( id ) AS max_id, count( id ) AS c FROM {table_name} GROUP BY {distinct_field} ) tmp_exclude_{table_name} 
  11. );