/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

18 votes118 views6 answers
Creating table in MySQL
SQL
3 votes118 views2 answers
Create schema postgres
SQL
0 vote118 views1 answer
Utiliser sql ligne de commande
SQL
1 vote109 views1 answer
Set mysql mode global query
SQL
13 votes117 views2 answers
Sqlite rename column
SQL
0 vote113 views1 answer
Mysql read row
SQL
1 vote130 views1 answer
Oracle compile schema
SQL
0 vote131 views2 answers
Null value in column violates not-null constraint
SQL
0 vote106 views1 answer
Change default schema sql server
SQL
5 votes142 views3 answers
Db begintransaction laravel
SQL