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 по дате отправления: