Selecting rows but disregarding repetition of cell values

Question

I have a table of customers that has repetition of first names and last names. I don't know what type of select query should I use to display specific row regarding their same entries.

Example: Table: customers

customer_id|firstname|lastname
-----------+---------+---------
0000000001 |Peter    |Griffin
0000000002 |Peter    |Pan
0000000003 |Mary     |Magdalene
0000000003 |Mary     |Jane

And the output I want is like is:

customer_id|firstname|lastname
-----------+---------+---------
0000000001 |Peter    |Griffin
0000000003 |Mary     |Magdalene

I know this is easy but I'm new to SQL.

I suppose the 4th row should have `customer_id` 4 instead of 3? — Erwin Brandstetter, Mar 03 '21 at 03:43

score 1 · Accepted Answer · answered Mar 03 '21 at 03:32

1

One way to do this is with DISTINCT ON:

SELECT DISTINCT ON (firstname)
       customer_id, firstname, lastname 
FROM   customers
ORDER  BY firstname, customer_id;

See:

Select first row in each GROUP BY group?

answered Mar 03 '21 at 03:32

Erwin Brandstetter

605,456
145
1,078
1,228

I'll try this, Thanks! :) – Joshua Galang Mar 03 '21 at 03:42

Selecting rows but disregarding repetition of cell values

1 Answers1