/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 vote255 views1 answer
SQL Server dynamic pivot unknown number of columns
SQL
8 votes271 views1 answer
Mysql dump restore
SQL
0 vote240 views1 answer
Placements hackerrank solution
SQL
0 vote245 views1 answer
Change filed order in mysql
SQL
0 vote232 views1 answer
How to change mysql port in xampp
SQL
0 vote407 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote228 views1 answer
Cara menampilkan user di mysql terminal
SQL
1 vote219 views1 answer
How to delete record sql delphi
SQL
11 votes269 views1 answer
Oracle export view ddl
SQL
0 vote254 views1 answer
Oracle drop type
SQL