/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

7 votes300 views3 answers
Postgre describe table
SQL
0 vote306 views1 answer
Gcloud check sql
SQL
0 vote302 views1 answer
Tsql cmd exec script from file
SQL
3 votes321 views2 answers
Oracle drop column
SQL
0 vote325 views1 answer
PSQL use LIKE with timestamps
SQL
7 votes306 views2 answers
N highest salary in sql
SQL
0 vote337 views2 answers
Sql day from datetime
SQL
0 vote357 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
1 vote526 views2 answers
Sql unique rows
SQL
1 vote317 views1 answer
Get parameter value in mysql trigger
SQL