/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 vote127 views2 answers
Mysql type conversion
SQL
3 votes145 views1 answer
Null sql
SQL
3 votes262 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
6 votes134 views2 answers
Mysql concatenate two columns into one
SQL
0 vote156 views1 answer
Grant privileges mysql to database 1064
SQL
2 votes141 views2 answers
Mysql find max value row
SQL
0 vote154 views1 answer
How to install Firebird
SQL
1 vote128 views1 answer
Select dba users oracle
SQL
0 vote128 views1 answer
Metada in sql
SQL
2 votes136 views1 answer
Sql as
SQL