/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

3 votes280 views1 answer
How to find names includes in sql
SQL
2 votes283 views3 answers
Postgres create view
SQL
10 votes280 views1 answer
Oracle dba_dependencies
SQL
0 vote251 views1 answer
Sql server is not
SQL
104 votes446 views2 answers
Like in mysql
SQL
0 vote277 views1 answer
Ms sql database data size
SQL
6 votes286 views2 answers
Postgresql restore from dump
SQL
1 vote268 views1 answer
Grab all records from one table to another oracle sql
SQL
0 vote306 views1 answer
Date 3 months from today sql
SQL
0 vote262 views2 answers
Show slave status mysql
SQL