/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 vote365 views3 answers
Query string not ending with with vowels
SQL
0 vote369 views1 answer
How change the field place in mysql
SQL
3 votes367 views1 answer
Postgresql db owner change
SQL
1 vote366 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote406 views1 answer
Sqlcl format
SQL
5 votes350 views1 answer
Pl sql asynchronous procedure calls
SQL
10 votes349 views4 answers
Fetch first 5 characters of the string in sql
SQL
0 vote371 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote395 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote357 views1 answer
NLS_NCHAR_CHARACTERSET
SQL