/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

2 votes209 views1 answer
Plsql block
SQL
6 votes198 views1 answer
Phpmyadmin reset root password
SQL
0 vote212 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
38 votes249 views6 answers
Ubuntu install mysql client
SQL
28 votes220 views4 answers
Show tables mysql
SQL
0 vote225 views1 answer
Sql show table name in result
SQL
7 votes238 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote208 views1 answer
Mysql error codeigniter
SQL
1 vote247 views1 answer
Find size of all DB's postgres
SQL
14 votes234 views3 answers
Oracle sql limit results
SQL