SQL Queries for Finding Duplicate Rows and Recursive Hierarchical Data

Advanced PostgreSQL query snippets utilizing Common Table Expressions (CTEs) and window functions (like ROW_NUMBER() and CONNECT BY equivalents) to clean up duplicate records and fetch nested tree structures.