/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

19 votes155 views6 answers
Sql server drop table if exists
SQL
0 vote169 views1 answer
Sql remove non numeric characters
SQL
15 votes184 views4 answers
Sql update from select
SQL
0 vote140 views1 answer
Mysql select statement after index
SQL
11 votes140 views2 answers
Having clause
SQL
-1 vote152 views1 answer
Insert results of a stored procedure into a temporary table
SQL
2 votes152 views2 answers
Mysql get time from datetime
SQL
5 votes148 views3 answers
How to remove unique key constraint in mysql
SQL
3 votes160 views3 answers
Create table in microsoft sql server
SQL
0 vote147 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL