Monday, 5 September 2022

Postgresql - Identify duplicate rows

SELECT (mytablename.*)::text, count(*)

FROM mytablename

GROUP BY mytablename.*

HAVING count(*) > 1

No comments:

Snowflake - Notes

WPRKSPACES -  In September 2025, Snowflake introduced Workspaces, which combines the functionality of Worksheets, Notebooks, File Manager, Q...