/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 vote198 views1 answer
Add super privilege mysql
SQL
1 vote177 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote152 views1 answer
Mysql create table columns with spaces
SQL
1 vote180 views1 answer
Tsql get beginning of year
SQL
1 vote175 views1 answer
Oracle repeat_interval 5 minutes
SQL
3 votes174 views3 answers
Sql last week
SQL
6 votes163 views3 answers
Mysql change auto_increment start value
SQL
25 votes174 views5 answers
Uninstall mysql ubuntu
SQL
6 votes177 views5 answers
Mysql get last insert id
SQL
0 vote182 views1 answer
Restart sql server command line linux
SQL