同时查询最大最小值的效率问题(三)

2014-11-24 11:32:45 · 作者: · 浏览: 3
1 rows processed
--可见,这种情况效率是最高的
SELECT MIN, MAX
FROM (SELECT MIN(created) AS MIN FROM user_objects_tmp) a,
(SELECT MAX(created) AS MAX FROM user_objects_tmp) b;