面试官为何说此语句有错！
id????????? name???????????????? age???????? manager????
----------- -------------------- ----------- -----------
1?????????? aaa????????????????? 55????????? 0
2?????????? bbb????????????????? 222???????? 1
3?????????? ccc????????????????? 32????????? 1
4?????????? ddd????????????????? 635???????? 2
5?????????? eee????????????????? 32????????? 2
6?????????? fDD????????????????? 23????????? 1
例如:id为2的员工年龄为222而他的manager的年龄1只有55岁所以要打印出2号员工的信息
?
SQL：select * from users u,users u1 where u.uid=u1.manager and u.age>u1.age
?
面试错为何说此语句有错！
1 楼 mudong 2008-12-26 select * from users u,users u1 where u.uid=u1.manager and u.age<u1.age 2 楼 mercyblitz 2008-12-26 select * from users u,u1 where u.uid=u1.manager and u.age>u1.age