/SQL/How to get distinct sets of rows using SQL (Oracle)?

How to get distinct sets of rows using SQL (Oracle)?

WITH hashes AS
(SELECT group,
        SUM(Ora_hash(Concat(Concat(account,field), value))) AS hash
 FROM table
 GROUP BY group)
SELECT account,
       field,
       value,
       group
FROM table
WHERE group IN (SELECT group
                FROM (SELECT group,
                             row_number() over (PARTITION BY hash ORDER BY NULL) AS rn
                      FROM hashes)
                WHERE  rn = 1);

Source: stackoverflow.com

Similar codes

4 votes185 views4 answers
Pl sql output
SQL
3 votes206 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote166 views1 answer
Ms sql unique
SQL
0 vote164 views1 answer
Ms sql database data size
SQL
0 vote209 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote173 views1 answer
Components/Fields of Internal Table
SQL
12 votes185 views4 answers
Mysql version
SQL
1 vote165 views1 answer
Sql upsert
SQL
1 vote190 views1 answer
T-SQL / AZURE Reseed
SQL
1 vote166 views1 answer
Hexadec to sql REDSHIFT
SQL