/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

8 votes361 views1 answer
Sql limit results returned
SQL
0 vote351 views1 answer
How to connect postgresql database with java
SQL
-1 vote390 views1 answer
Add 10 to all numbers in a column sql
SQL
12 votes343 views2 answers
Delete all nodes neo4j
SQL
2 votes350 views1 answer
Oracle sql day of month from date
SQL
1 vote335 views1 answer
Mysql column start with string
SQL
4 votes380 views1 answer
How to drop a database in sql server when it is in use
SQL
1 vote369 views1 answer
Mysql return text after a final full stop
SQL
1 vote363 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote380 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL