/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

1 vote224 views1 answer
Add current timestamp in mysql
SQL
1 vote246 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote237 views1 answer
OFFSET consulta mysql
SQL
0 vote210 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote221 views1 answer
Mysql_union
SQL
0 vote220 views1 answer
Make a socket server to detect changes in mysql
SQL
1 vote217 views1 answer
Postgres format date in select
SQL
0 vote258 views1 answer
Sql date with year
SQL
0 vote336 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote219 views1 answer
How to fix mysql stop unexpectedly
SQL