/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

14 votes290 views1 answer
How to export db from mysql
SQL
1 vote217 views2 answers
Postgres cast as decimal
SQL
2 votes195 views1 answer
Sqlite show table indexes
SQL
1 vote213 views1 answer
Sql select where id not exists in another table
SQL
3 votes276 views1 answer
Oracle function
SQL
0 vote202 views1 answer
Mysql date only no time
SQL
0 vote220 views2 answers
Insert data mysql with cmd
SQL
0 vote218 views1 answer
How to get nth number in sql
SQL
0 vote208 views1 answer
Java sql timestamp now
SQL
0 vote220 views1 answer
Use where instead of join
SQL