/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

0 vote189 views1 answer
Login failed for login due to trigger execution
SQL
0 vote189 views1 answer
Zsh: command not found: mysql mamp
SQL
0 vote194 views3 answers
Sql select statements
SQL
0 vote192 views1 answer
Eliminar ultimo carcacter mysql
SQL
4 votes215 views2 answers
Oracle last day of month
SQL
0 vote205 views1 answer
Cast as decimal postgresql
SQL
21 votes207 views4 answers
Oracle add column
SQL
0 vote202 views1 answer
Merge clause with inner join
SQL
0 vote186 views1 answer
Postgresql conectar
SQL
0 vote166 views1 answer
Online sql compiler
SQL