/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

4 votes131 views1 answer
Psql get sequences
SQL
1 vote137 views2 answers
T-sql random number for each row
SQL
0 vote131 views1 answer
Mariadb maximum left join
SQL
2 votes136 views1 answer
How to select first row of database sql
SQL
0 vote147 views1 answer
Postgresql custom order by
SQL
1 vote130 views2 answers
Sql for date greater than
SQL
17 votes163 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote138 views1 answer
Change date in pivot table to month in sql server
SQL
5 votes148 views4 answers
Change auto increment mysql
SQL
1 vote265 views1 answer
Import sql file from laravel
SQL