/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 vote363 views2 answers
Postgresql get last 10 records
SQL
0 vote336 views1 answer
Sqlite3 get data from table c
SQL
8 votes364 views2 answers
Alert table name mysql
SQL
0 vote380 views1 answer
Postgres list users and roles
SQL
7 votes333 views2 answers
N highest salary in sql
SQL
1 vote329 views1 answer
Temp table vs variable table in sql server
SQL
0 vote333 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote328 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote339 views1 answer
Like and not like together in sql
SQL
0 vote448 views1 answer
Delet all record statment sql
SQL