/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 vote415 views1 answer
Create pl/sql stored procedure
SQL
0 vote142 views1 answer
Postgresql parse json array
SQL
3 votes141 views2 answers
Find the median in sql
SQL
5 votes145 views1 answer
Oracle sysdate
SQL
0 vote150 views1 answer
Enable Rabbitmq management plugin
SQL
4 votes138 views2 answers
Postgres update single column
SQL
0 vote243 views4 answers
Stored procedure sql
SQL
0 vote134 views1 answer
Mysql multiple count
SQL
10 votes141 views1 answer
Create table oracle
SQL
23 votes130 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL