/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 vote258 views10 answers
Delete Query in SQL Server
SQL
5 votes278 views4 answers
Describe table postgres
SQL
6 votes307 views2 answers
What is non relational database
SQL
6 votes357 views2 answers
Oracle undotbs usage
SQL
0 vote302 views1 answer
Longtext sql
SQL
-3 votes385 views8 answers
Sql to c# linq converter online
SQL
9 votes293 views2 answers
Sql limit order by
SQL
2 votes296 views1 answer
Compare date in sql
SQL
3 votes320 views1 answer
Laravel paginate raw sql
SQL
2 votes311 views2 answers
Convert_tz mysql
SQL