/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 vote270 views1 answer
Mysql change innodb to myisam
SQL
0 vote260 views1 answer
Mysql in clausule string array
SQL
0 vote262 views1 answer
Microsoft sql server python connection
SQL
-1 vote264 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote261 views1 answer
Test database for sql
SQL
0 vote256 views2 answers
Nosqlbooster query other collection
SQL
0 vote269 views1 answer
Sparql if bound query
SQL
1 vote282 views1 answer
How to delay stored procedure execution in sql server
SQL
0 vote273 views1 answer
Ms sql print more than 1 variable
SQL
0 vote277 views1 answer
Mariadb set vertical output format
SQL