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

 

From: Rob Sargent

Date: 2022-10-25 22:06

To: jacktby

CC: pgsql-general

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

div.FoxDIV_20221025220947792 { font-size: 10.5pt } div.FoxDIV_20221025220947792 { line-height: 1.5; } div.FoxDIV_20221025220947792 { font-size: 14px; font-family: "Microsoft YaHei UI"; color: rgb(0, 0, 0); line-height: 1.5; }

On Oct 25, 2022, at 7:55 AM, jacktby@gmail.com wrote:



typedef enum SetOperation

{

    SETOP_NONE = 0,

    SETOP_UNION,

    SETOP_INTERSECT,

    SETOP_EXCEPT

} SetOperation;

---

jacktby@gmail.com

Please use just text. 

What ‘dialect’ are using? In Postgres

0: select * from table

1: select * from table union select * from table is same shape

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

3: select * from table except select * from tableb