|
我现在有一个表,如下
Table 1: Example Emp Relation
eid mgrid ename salary level
e001 NULL John Smith 100,000 1
e002 e001 Joe McDonald 80,000 2
e004 e001 Peter Stone 70,000 2
e007 e002 Kris White 40,000 3
e011 e002 Pit Steward 60,000 3
e012 e004 Mary Liu 50,000 4
e013 e011 Kaushik Gupta 40,000 4
怎么写求一个结点的所有父结点和子结点SQL语句?
请斑竹和各位高手给予指教! |
|