/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 vote183 views2 answers
Mysql missin expression near on
SQL
1 vote121 views1 answer
Mysql collation
SQL
1 vote156 views1 answer
Create table tablename as select * from tablename
SQL
0 vote166 views1 answer
Openquery insert into linked server
SQL
0 vote164 views1 answer
Vowels in sql
SQL
0 vote194 views1 answer
Reset postgres table index to next max value
SQL
0 vote176 views1 answer
Como hacer una consulta en sql
SQL
9 votes189 views1 answer
Alter table column change data type to text mysql
SQL
0 vote159 views1 answer
Mysql find db contarint
SQL
0 vote170 views1 answer
Alter table engine mysql
SQL