#54 - QGIS - Find double geometries with an easy sql query

This is an easy way to find double geometries with an easy sql query.
This is the full query:
select * from
(SELECT , COUNT(geometry) as *newColumnName FROM yourLayer group by geometry) as newTableName where newTableName.*newColumnName bigger 1
Please write it in the comments, if you have any advice to improve my tutorials or suggestions for further tutorials.