/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 vote334 views1 answer
Mysql order by on condition
SQL
6 votes320 views2 answers
Return columns from table sql
SQL
0 vote357 views1 answer
Show specific events on mysql
SQL
2 votes326 views2 answers
Mysql date range
SQL
1 vote320 views1 answer
Sql auto date
SQL
0 vote333 views1 answer
Sql server datetime
SQL
1 vote340 views1 answer
Wordpress change url phpmyadmin
SQL
1 vote365 views1 answer
Get current date in pyspark sql
SQL
0 vote337 views1 answer
Mysql min value row
SQL
2 votes371 views1 answer
Oracle Column Names of a table
SQL