Ajit Pradnyavant writes:
> I think result of INTERSECT ALL query may be :
> Srno Name
> 1 Aaaa
> 1 Aaaa
> Because intersect all clause returns the duplicate values.
No; per the documentation at
http://www.postgresql.org/docs/9.1/static/sql-select.html#SQL-INTERSECT
The result
Sir,
I have created the following tables,
Create table abc (srno int, name varchar(32))
Create table def (srno int, name varchar(32))
abc
srnoname
1 Aaaa
2 Bbbb
def
srnoname
1 Aaaa
2 Cccc
each having two tuples.
If I run the following query I get the fo
