/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 vote123 views1 answer
Mysql get only the field names in a table
SQL
0 vote99 views1 answer
Sqlite explain plan
SQL
0 vote105 views1 answer
Update one column from another column in same table
SQL
0 vote104 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote105 views1 answer
Check psql validity function
SQL
5 votes113 views1 answer
Oracle asynchronous update
SQL
1 vote110 views1 answer
Drop function
SQL
19 votes106 views6 answers
Laravel sql query
SQL
2 votes102 views1 answer
Plsql left() function
SQL
0 vote159 views1 answer
Replace null value within column mysql
SQL