Database System Concepts - Set Operation

Question

UNION, Intersect Operation in both, Relational Algebra and SQL automatically eliminates DUPLICATES. Does UNION, INTERSECT operation also by default SORTs the resultant tuples in SQL (OR) the resultant SET in Relational Algebra? If Yes, Does it also automatically sorts the result of UNION ALL &  INTERSECT ALL?

Comments

they are sort (by default), which tuple seems first in the table.

But not the values of any field.

i mean, in your table, you have

id  name

2 "A"

1 "C"

3 "B"

like that then the sort also in the tuple wise, but not on the attribute (either id or name) wise.

---

Yeah, I get that the tuples are sorted not the attributes. Can you please elaborate how tuples are sorted, I mean on what basis they get compared!

---

Table₁ intersect Table₂

then first row of Table₁ compared all the rows of Table₂ ... if it is matched then print in result.