This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / If you are a programmer, do you know how many types of SQL Joins there are?
-verano(Summer);
2014-9-22
{44}
(#9001058@0)
-
A programmer should know 3 types of joins: nested loop join, sort-merge join and hash join.
-geekcode(文心雕码);
2014-9-22
(#9002258@0)
-
Oops! I know none of them! :(
-verano(Summer);
2014-9-23
(#9003941@0)
-
this join is not that join :-)
-fallingfromsky(异想天开 );
2014-9-25
(#9008179@0)
-
inner join, left join, right join.
-boolean(北漂一族);
2014-11-11
(#9095126@0)
-
一般key都是不null的，所以简化一下就是4种
-stanleywang(HeyStan);
2014-11-27
(#9123004@0)
-
就我的理解有三种：Inner (包括Self-Join), Outer (Full, Left, Right), 及 Cross Join (无需 JOIN 条件)
-deep_blue(BLUE);
2014-11-27
(#9124629@0)