/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

13 votes186 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote182 views1 answer
Soql more than today
SQL
0 vote189 views1 answer
Postgres statistics
SQL
18 votes266 views3 answers
Get the list of all tables in sql server
SQL
0 vote192 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote184 views1 answer
Postgresql interview questions
SQL
1 vote172 views1 answer
Index a database column sql
SQL
1 vote175 views1 answer
Funzioni plsql
SQL
6 votes191 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
1 vote138 views1 answer
Mssql string length
SQL