/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 vote214 views1 answer
Safe mysql
SQL
1 vote192 views1 answer
Access the postgres psql
SQL
1 vote194 views2 answers
Mysql current user
SQL
2 votes202 views1 answer
Oracle find constraints referencing a table
SQL
0 vote183 views1 answer
Check if a word appears at the end sql query
SQL
0 vote224 views1 answer
Plpgsql if statement
SQL
0 vote203 views1 answer
C# get sql min date
SQL
2 votes205 views1 answer
Mysql id of inserted row
SQL
8 votes197 views1 answer
Sql remove leading spaces
SQL
0 vote266 views1 answer
Postgresql create table default value timestamp
SQL