/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 vote103 views2 answers
Mysql disable foreign key checks
SQL
17 votes107 views4 answers
Set mysql Password
SQL
0 vote118 views1 answer
Mysql Digital Ocean connection problems
SQL
1 vote125 views1 answer
Delete specific row in sql
SQL
0 vote105 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote117 views1 answer
Mysql update even / odd rows
SQL
0 vote107 views1 answer
Null column as zero in mysql
SQL
0 vote103 views1 answer
How to check even or odd in sql
SQL
4 votes102 views1 answer
Mysql insert from local csv
SQL
-1 vote117 views2 answers
Installing mysql on centos 7
SQL