/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 vote113 views1 answer
Redirection 301 htaccess nom de domaine
SQL
0 vote152 views1 answer
Mysql faster delete
SQL
3 votes76 views1 answer
V$session not found in oracle
SQL
0 vote114 views1 answer
Oracle sql winter time change
SQL
18 votes118 views3 answers
Mysql add column with default value
SQL
1 vote113 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
12 votes105 views1 answer
How to change the value of a table in sql
SQL
1 vote128 views2 answers
Sql insert timestamp
SQL
0 vote113 views1 answer
Postgresql array to rows
SQL
7 votes129 views1 answer
Sql limit decimal places
SQL