delete duplicate rows from table. Not Working!

[mubeenfahmed]

I am trying to delete duplicate records from table, using following query, but its not working.

Delete FROM users GROUP BY name, email HAVING COUNT(*) > 1

It just throw following errors: SQLiteException: near "count": syntax error. SQLiteException: near "group": syntax error SQLiteException: near "having": syntax error

what should I do, Need Help!

[Salbrox]

You should be using % as wildcard not * if i'm not mistaken.