/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 vote359 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
3 votes271 views1 answer
If 0 return null else return query mysql
SQL
0 vote296 views3 answers
Convert sql query to python pandas
SQL
0 vote316 views2 answers
Imageview setimageresource null
SQL
0 vote285 views1 answer
Oracle execute immediate quotes
SQL
12 votes299 views5 answers
Sql primary key
SQL
24 votes315 views4 answers
Delete db postgres
SQL
0 vote293 views1 answer
Date diff sql
SQL
0 vote315 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
5 votes295 views1 answer
Oracle get nls settings
SQL