On Friday, May 22, 2020, Scott Ribe <scott_r...@elevated-dev.com> wrote:
> given, let's say: > > create table person (id int not null, name varchar); > create table phone (id int not null, person_id int not null, number > varchar); > > select person.*, phone.number from person join phone on (person.id = > phone.person_id) order by... > > How would you get results where only the first row for a person was filled > in, with rest of that person's phones showing blanks for those columns? I'm > guessing that window functions provide this capability, but I don't know > how. > > If a left join doesn’t give you the answer you want you should probably provide exact input and output data that you are working with/toward. David J.