SQL の ORDER BY
2003-11-24-1
SELECT a, MAX(a) AS max_a FROM hoge ORDER BY max_a;
と
SELECT a, MAX(a) FROM hoge ORDER BY 2;
は同義.
Oracle,MySQL で確認
2003-11-24-1
SELECT a, MAX(a) AS max_a FROM hoge ORDER BY max_a;
と
SELECT a, MAX(a) FROM hoge ORDER BY 2;
は同義.
Oracle,MySQL で確認