group by 的别名
SELECT
COUNT(chuto_no) chuto_no,nyuiki_ymd,
SUM(senryo_xganma) senryo_xganma,
CASE
WHEN (SUBSTR(chuto_no, 4, 1) = 'A') THEN
'A'
WHEN (SUBSTR(chuto_no, 4, 1) = 'E') THEN
'E'
END AS FENLI
FROM
KJNT_TACHIIRI_KANRI
GROUP BY nyuiki_ymd,
CASE
WHEN (SUBSTR(chuto_no, 4, 1) = 'A') THEN
'A'
WHEN (SUBSTR(chuto_no, 4, 1) = 'E') THEN
'E'
END
ORDER BY nyuiki_ymd
上面的语句中用了两次
CASE
WHEN (SUBSTR(chuto_no, 4, 1) = 'A') THEN
'A'
WHEN (SUBSTR(chuto_no, 4, 1) = 'E') THEN
'E'
END
能否用别名，只写一次，但是我在select部分用别名，提示我无法识别。
请教怎么做？
问题点数：20、回复次数：3Top
1 楼shanbingch（男人）回复于 2005-04-04 17:24:34 得分 5
ORDER BY 中好像不可以用别名Top
2 楼liuyi8903（不让疑问伴随）回复于 2005-04-04 19:57:56 得分 10
order by 是可以用别名的。
group by 就不可能用别名。除非嵌套一层sqlTop
3 楼wypudong（叶叶）回复于 2005-04-05 16:08:35 得分 5
group by 不能用别名Top
