Help for this page

Select Code to Download


  1. or download this
    SELECT
        y.id,y.name,y.email
    ...
                            GROUP BY name,email
                            HAVING COUNT(*)>1
                        ) dt ON y.name=dt.name AND y.email=dt.email
    
  2. or download this
    sqlite> 
    CREATE TABLE "table"(ID,Tag1,Tag2);
    ...
    ----------  ----------  ----------
    1           science     math      
    4           science     math