/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 vote144 views1 answer
Mysql terminal list table
SQL
6 votes153 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote128 views1 answer
Dnsmasq.conf location macos
SQL
0 vote162 views1 answer
Sql injection payload list github
SQL
1 vote143 views2 answers
Difference between in and between in sql
SQL
1 vote145 views3 answers
String to int mysql
SQL
5 votes190 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
0 vote161 views1 answer
Full outer join in mariadb mysql
SQL
0 vote144 views1 answer
Get employees if not contains in sql
SQL
-1 vote151 views2 answers
Full join sql
SQL