/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

103 votes2.5K views1 answer
Like sql
SQL
0 vote212 views2 answers
Insert data mysql with cmd
SQL
0 vote237 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
3 votes243 views1 answer
How to uninstall microsoft sql server
SQL
0 vote193 views2 answers
Sql update top 100
SQL
0 vote265 views1 answer
How to check event scheduler status mysql
SQL
0 vote244 views1 answer
Sql select merge multiple values
SQL
3 votes203 views2 answers
Tsql join multiple record in one string
SQL
47 votes290 views6 answers
Add column mysql
SQL
6 votes256 views2 answers
Return columns from table sql
SQL