/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 vote250 views1 answer
Mysql group by derived column
SQL
5 votes270 views1 answer
Sort order on two columns sql
SQL
0 vote232 views2 answers
Sql update from two different database
SQL
0 vote255 views1 answer
Oracle call a function in a insert statement
SQL
0 vote256 views1 answer
How to put is null in where in clause
SQL
2 votes273 views1 answer
Mysql last 7 days including today
SQL
0 vote254 views1 answer
Set column width in sqlplus
SQL
0 vote281 views1 answer
Wordpress database query change url
SQL
0 vote260 views1 answer
Set default value now() date
SQL
11 votes274 views1 answer
Oracle insert into where
SQL