主题：寻求JAVA资料

select number,name from stu as old where number< any(select number from stu where name=old.name)的显示结果是没有符合条件的记录，

而输入select number,name from stu as old where number< any(select number from stu as old where name=old.name)却显示了正确结果，这是什么原因？