/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

3 votes135 views2 answers
Install mysql powershell
SQL
0 vote139 views1 answer
Sqlite3 not commit
SQL
0 vote130 views1 answer
Mysql select where field is a value
SQL
0 vote164 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote127 views1 answer
Mysql add to number
SQL
0 vote135 views1 answer
Less mysql display
SQL
0 vote236 views1 answer
Why do we need data structure in sql
SQL
8 votes117 views1 answer
Unique vs primary key
SQL
-1 vote133 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
21 votes126 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL