Help for this page

Select Code to Download


  1. or download this
    SELECT 
      DISTINCT * 
    ...
    WHERE 
      A.ID = B.ID and 
      A.SECONDCOLUMN != B.SECONDCOLUMN
    
  2. or download this
    SELECT
       COUNT(*)
    ...
      ) as COUNTS
    WHERE
      CNT = 1