/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

1 vote127 views1 answer
Spring postgresql reset auto increment to 0
SQL
1 vote140 views1 answer
Sql row having max
SQL
0 vote141 views1 answer
Sql server roles and users
SQL
17 votes148 views2 answers
Mysql date to string
SQL
0 vote173 views1 answer
Sql select without column name
SQL
0 vote131 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote92 views1 answer
Mysql workbench search all tables
SQL
0 vote137 views1 answer
Error code 1451 sql
SQL
0 vote129 views1 answer
Jenkins SQLCMD run
SQL
1 vote134 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL