Re: please give me select sqls examples to distinct these!

2022-10-25 Thread Rob Sargent
On 10/25/22 09:58, David G. Johnston wrote: On Tue, Oct 25, 2022 at 8:56 AM Rob Sargent wrote: On 10/25/22 09:24, David G. Johnston wrote: On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston wrote: On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent wrote: 2

Re: please give me select sqls examples to distinct these!

2022-10-25 Thread David G. Johnston
On Tue, Oct 25, 2022 at 8:56 AM Rob Sargent wrote: > On 10/25/22 09:24, David G. Johnston wrote: > > On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent >> wrote: >> >>> >>> >>> 2: select * from table join tabl

Re: please give me select sqls examples to distinct these!

2022-10-25 Thread Rob Sargent
On 10/25/22 09:24, David G. Johnston wrote: On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston wrote: On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent wrote: 2: select * from table join table b on Id = idb #2 is probably conceptually correct but in this context should be

Re: please give me select sqls examples to distinct these!

2022-10-25 Thread David G. Johnston
On Tue, Oct 25, 2022 at 8:22 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent wrote: > >> >> >> 2: select * from table join table b on Id = idb >> >> >> > #2 is probably conceptually correct but in this context should be written > as: > > Act

Re: please give me select sqls examples to distinct these!

2022-10-25 Thread David G. Johnston
On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent wrote: > > > On Oct 25, 2022, at 7:55 AM, jack...@gmail.com wrote: > >  > > typedef enum SetOperation > { > SETOP_NONE = 0, > SETOP_UNION, > SETOP_INTERSECT, > SETOP_EXCEPT > } SetOperation; > -- > jack...@gm

Re: Re: please give me select sqls examples to distinct these!

2022-10-25 Thread jack...@gmail.com
> On Oct 25, 2022, at 7:55 AM, jack...@gmail.com wrote: > >  > > typedef enum SetOperation > { > SETOP_NONE = 0, > SETOP_UNION, > SETOP_INTERSECT, > SETOP_EXCEPT > } SetOperation; > jack...@gmail.com Please use just text. What ‘dialect’ are using? In Postgres 0: select * from

Re: please give me select sqls examples to distinct these!

2022-10-25 Thread Rob Sargent
> On Oct 25, 2022, at 7:55 AM, jack...@gmail.com wrote: > >  > > typedef enum SetOperation > { > SETOP_NONE = 0, > SETOP_UNION, > SETOP_INTERSECT, > SETOP_EXCEPT > } SetOperation; > jack...@gmail.com Please use just text. What ‘dialect’ are using? In Postgres 0: select * from

please give me select sqls examples to distinct these!

2022-10-25 Thread jack...@gmail.com
typedef enum SetOperation { SETOP_NONE = 0, SETOP_UNION, SETOP_INTERSECT, SETOP_EXCEPT } SetOperation; jack...@gmail.com