/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 vote265 views1 answer
Sql datediff month
SQL
0 vote290 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL
7 votes290 views2 answers
Postgres concat
SQL
3 votes291 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote285 views2 answers
Search stored procedures by name
SQL
1 vote266 views1 answer
Primary key reset in SQL database
SQL
0 vote306 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote262 views1 answer
Oracle select invalid views
SQL
0 vote293 views1 answer
Create table database in psql
SQL
0 vote349 views1 answer
Redshift running queries
SQL