Brisanje dupliranih konatakata

DELETE t1 FROM contacts t1
INNER JOIN contacts t2 
WHERE 
    t1.id < t2.id AND 
    t1.email = t2.email;Code language: SQL (Structured Query Language) (sql)

-1

Source: mysqltutorial.org

Similar codes

0 vote191 views1 answer
Mysql_error replacement
SQL
0 vote192 views1 answer
Sql find all different values in column
SQL
0 vote219 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote205 views1 answer
Sqlalchemy get schema from database
SQL
0 vote232 views1 answer
Plsql check for string in numeric
SQL
0 vote196 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
1 vote187 views2 answers
String to date postgres
SQL
3 votes226 views1 answer
Apex set debug level
SQL
1 vote255 views1 answer
How to get alternate records from a table in sql
SQL
2 votes195 views1 answer
Compare date in sql
SQL