/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

6 votes148 views2 answers
Find mysql version linux
SQL
0 vote153 views1 answer
Sql change date format
SQL
7 votes159 views1 answer
Connect mysql docker
SQL
0 vote155 views1 answer
Sql select all tables from database change url
SQL
0 vote166 views1 answer
Select all columns except one sql
SQL
1 vote105 views1 answer
Metada in sql
SQL
-1 vote154 views2 answers
REMOVE DATE FROM DATE TIME SQL SERVER
SQL
3 votes178 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
0 vote161 views1 answer
Sqlalchemy get ids
SQL
0 vote172 views1 answer
Datagrip execute procedure
SQL