/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

4 votes336 views2 answers
Convert utc to est sql
SQL
46 votes397 views4 answers
Create column sql
SQL
7 votes393 views3 answers
Sql server check if temp table exists
SQL
0 vote360 views3 answers
Fetlife
SQL
0 vote391 views2 answers
Clauses in mysql
SQL
1 vote338 views1 answer
Can not connect to mysql server
SQL
0 vote331 views1 answer
Soql user profile
SQL
1 vote360 views1 answer
Mysql datetime with timezone offset
SQL
0 vote349 views1 answer
Mysql error 1452
SQL
0 vote330 views1 answer
Pip install mysqlclient error
SQL