select goal from mytable where ... INTERSECT select goal from mytable where ... 关键字为【INTERSECT】 非常有用的一个词~