/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 vote217 views1 answer
Convert polygon to text in mysql
SQL
0 vote280 views1 answer
Sqlalchemy query return only n results
SQL
1 vote197 views1 answer
Moodle query item quiz
SQL
0 vote197 views1 answer
Postgresql remove duplicate rows 2 columns
SQL
0 vote220 views1 answer
What is top n result in sql
SQL
0 vote193 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL
0 vote223 views3 answers
Delete in SQL SERVER
SQL
0 vote182 views1 answer
Dnsmasq.conf location macos
SQL
0 vote225 views1 answer
Power bi find all ids not in other tables
SQL
2 votes161 views1 answer
Latest record in sql
SQL