(2) select * from table where color='red' order by num;
(3) select * from table where color='blue' AND num > ANY (select max(num) from table where color='red')
第 5 页 共 6页
(2) select * from table where color='red' order by num;
(3) select * from table where color='blue' AND num > ANY (select max(num) from table where color='red')
第 5 页 共 6页