/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

10 votes205 views2 answers
Doublon sql
SQL
0 vote149 views1 answer
Pl/pgsql declare variable
SQL
0 vote130 views1 answer
Database xml sql
SQL
0 vote205 views1 answer
Sql database size
SQL
27 votes145 views6 answers
Sql update record
SQL
0 vote141 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote149 views1 answer
Sql set data from a select query to a temp table and insert
SQL
2 votes144 views1 answer
Postgresql format date dd/mm/yyyy
SQL
104 votes330 views2 answers
Like in mysql
SQL
0 vote128 views4 answers
First max salary in sql
SQL