/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 vote187 views1 answer
How to select even id in sql
SQL
7 votes150 views1 answer
Alter table add key sql
SQL
1 vote194 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote210 views1 answer
Sql multiple into
SQL
0 vote207 views2 answers
Add colum in sql
SQL
0 vote182 views1 answer
Oracle string substitution
SQL
2 votes203 views1 answer
Sql OR
SQL
0 vote190 views1 answer
Count characters of string mysql
SQL
2 votes178 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote165 views2 answers
Influxdb delete measurement based on date
SQL