/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

9 votes264 views2 answers
Default number in sql
SQL
-1 vote287 views1 answer
Search all database tables for a value sqlserver
SQL
0 vote330 views1 answer
Delete from table where length sql
SQL
3 votes271 views2 answers
Oracle sql drop sequence
SQL
2 votes285 views1 answer
Sql ends with string
SQL
-1 vote275 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
0 vote269 views2 answers
Mysql slave status
SQL
2 votes277 views1 answer
Apex date today add days
SQL
0 vote296 views1 answer
How to check event scheduler status mysql
SQL
-1 vote270 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL