trying to get only one row from each group

Question

I have a problem with DISTINCT ON. I have five different groups of people which include names and surnames. My goal is to get only one name per group (the first one). When try to use DISTINCT ON, I got an error.

SELECT DISTINCT ON (group_A) surname FROM table

I want my table to look like

group_A...surname_a
broup_B...surname_b
.
.
.

Thank you for your help

@GordonLinoff you've added the `psql` tag, which is specific to the PostgreSQL shell, which doesn't apply here. — fphilipe, Jun 12 '19 at 16:28

score 0 · Answer 1 · answered Jun 11 '19 at 19:10

0

The syntax in Postgres would be:

SELECT DISTINCT ON (group_A) group_A, surname
FROM table
ORDER BY group_A;

answered Jun 11 '19 at 19:10

Gordon Linoff

1,242,037
58
646
786

Thank very much. I am not using Postgres yet, is there any possibility how to write it in other softwares (I am using Navicat)? – betd1 Jun 11 '19 at 19:19
@betdavid1 . . . Navicat is an interface to databases, not a database itself. – Gordon Linoff Jun 11 '19 at 19:23

trying to get only one row from each group

1 Answers1