Select one row for each group

Oracle 11 |

0 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

-- 1 Group by groupcol,
-- 2 Sort by sortcol
-- 3 Add numeration for every group 
 
SELECT TABLE.*,
ROW_NUMBER() over (PARTITION BY TABLE.groupcol ORDER BY sortcol) AS rm -- set number for each group
FROM TABLE;
 
-- leave only one row for each group
 
SELECT * FROM
  (SELECT TABLE.*,
  ROW_NUMBER() over (PARTITION BY TABLE.groupcol ORDER BY sortcol) AS rm -- set number for each group
  FROM TABLE)
WHERE rm = 1;

Comments

01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎
01/01/70 12:00:00 AM UTC
Plain Text |
0 B
|
👍
/
👎

Pasted

Select one row for each group

Comments