/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 vote362 views1 answer
Sql constarint
SQL
9 votes341 views6 answers
Replace sql
SQL
0 vote305 views1 answer
Sql count null as 0
SQL
16 votes325 views2 answers
Add column to all tables after first column mysql
SQL
1 vote316 views1 answer
Return size of tables in mysql
SQL
0 vote326 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote323 views1 answer
Check if database exists sql
SQL
1 vote310 views1 answer
Postgres regex remove special characters
SQL
0 vote303 views1 answer
Procedures and functions in pl/sql
SQL
2 votes322 views1 answer
Columns Present in a table
SQL