How to group table below to receive this result.
Table:
| notification_gid | group_display_name |
|---|---|
| 1000 | Active |
| 1000 | Cobra |
| 1000 | dog |
| 1001 | Active |
| 1001 | Cobra |
| 1001 | dog |
| 1002 | Active |
| 1002 | Cobra |
| 1002 | dog |
Needed result:
| notification_gid | group_display_name |
|---|---|
| 1000 | Active |
| 1001 | Cobra |
| 1002 | dog |
Many thanks
Tried group by, row_number…
New contributor
Radim Motycka is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
8