Query regarding Intersect clause
От | Ajit Pradnyavant |
---|---|
Тема | Query regarding Intersect clause |
Дата | |
Msg-id | CAFu=Yd_UmEn0WXZZkwgsj6hyp5mq452xX-uDqGvg7yAeq0OvKg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Query regarding Intersect clause
|
Список | pgsql-general |
Sir, I have created the following tables, Create table abc (srno int, name varchar(32)) Create table def (srno int, name varchar(32)) abc srno name 1 Aaaa 2 Bbbb def srno name 1 Aaaa 2 Cccc each having two tuples. If I run the following query I get the following result. (Select name from abc) intersect (select name from def) Srno Name 1 Aaaa If I run the following query I get the following result. (Select name from abc) intersect all (select name from def) Srno Name 1 Aaaa I think result of INTERSECT ALL query may be : Srno Name 1 Aaaa 1 Aaaa Because intersect all clause returns the duplicate values. Please tell me I am wrong or correct. Thank you in anticipation. -- Sincerely, Ajit Pradnyavant. Email:- ajit.pradnyavant@gmail.com Phone No. 7385758326
В списке pgsql-general по дате отправления: