/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 votes174 views1 answer
Remove spaces sql 2008
SQL
0 vote148 views1 answer
Import sql file in mysql linux
SQL
0 vote184 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
1 vote194 views1 answer
Sql count value greater than
SQL
13 votes183 views6 answers
Current date sql
SQL
0 vote188 views1 answer
Mysql create index lost connection
SQL
0 vote220 views1 answer
Sqlite get date only
SQL
1 vote194 views1 answer
Sql server today minus n
SQL
0 vote185 views2 answers
Csv into data postgres
SQL
0 vote231 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL