Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 10/25/22 09:58, David G. Johnston wrote:
On Tue, Oct 25, 2022 at 8:56 AM Rob Sargent <robjsargent@xxxxxxxxx> 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.johnston@xxxxxxxxx> wrote:
On Tue, Oct 25, 2022 at 7:06 AM Rob Sargent <robjsargent@xxxxxxxxx> wrote:


2: select * from table join table b on Id = idb 



#2 is probably conceptually correct but in this context should be written as:


Actually, a join is NOT conceptually correct here - the output columns for "SELECT *" will be wrong.

David J.

OK.  TBH I thought this was the JOOQ list! Didn't notice the typedef.  So this is all about exact match "tables".

I suppose my #2 could be framed as
   
select a* from table as a join table as b on a.<criteria> = b.<criteria>
to be a functional equivalent of INTERSECT?

SELECT DISTINCT a.* 

David J.
Yeah, sorry.  Meant to distinguish to two "table" defs in some way.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux