/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 vote176 views1 answer
Lesser than or equal to symbol in postgres
SQL
49 votes305 views6 answers
Install mysql ubuntu
SQL
0 vote193 views1 answer
Mysql regex exact match
SQL
0 vote199 views1 answer
Intellij mysql set timezone
SQL
0 vote187 views1 answer
Check if database exists sql
SQL
0 vote221 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
16 votes182 views4 answers
Ascending order mysql
SQL
11 votes357 views4 answers
Round in sql
SQL
16 votes184 views4 answers
Mysql import from sql file
SQL
2 votes189 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL