Tuesday, 24 February 2009
Saturday, 21 February 2009
Tuesday, 10 February 2009
Visual Representation of SQL Joins + Set Notations
Throwing some Gyan on Sql Join/Set theory after reading an article on
Sql Joins in codeproject.
[Thanks to good old shool days set theory lectures.]
'A' & 'B' are two sets,
1) A n B = Inner Join ( 'n' -- Intersection)
2) A u (A n B) = left join ( 'u' -- union )
3) (A n B) u B = right join
4) A u B u (A n B) = outer join
5) A - B = Left join excluding inner join or relative complement
6) B - A = right join excluding inner join
7) (A - B) U (B - A) = outer join excluding inner join.
[Note:- Given the fact that Sql Joins are popular tech. interview question,you can use above stuff to impress your interviewer.I hope above set notions will help you to answer Sql Join Q?'s in a generic way rather than explaining using 'Table1' , 'Table2' etc.... ]
Sql Joins in codeproject.
[Thanks to good old shool days set theory lectures.]
'A' & 'B' are two sets,
1) A n B = Inner Join ( 'n' -- Intersection)
2) A u (A n B) = left join ( 'u' -- union )
3) (A n B) u B = right join
4) A u B u (A n B) = outer join
5) A - B = Left join excluding inner join or relative complement
6) B - A = right join excluding inner join
7) (A - B) U (B - A) = outer join excluding inner join.
[Note:- Given the fact that Sql Joins are popular tech. interview question,you can use above stuff to impress your interviewer.I hope above set notions will help you to answer Sql Join Q?'s in a generic way rather than explaining using 'Table1' , 'Table2' etc.... ]
Sunday, 1 February 2009
Subscribe to:
Posts (Atom)