求分组显示多加几列的问题？

[ninewin]

select 'te1' as ttcode,'te2' as ttname,sum(amount) as amt from t1 group by 'te1','te2'

其中ttcode,ttname 都是表内没有的字端

我只是要按要求显示，同时不改动数据库的结构

[zjcxc]

select 'te1' as ttcode,'te2' as ttname,sum(amount) as amt from t1

[zjcxc]

既然是派生的, 所以也不存在要group by 的问题.

[wangdehao]

select 'te1' as ttcode,'te2' as ttname,sum(amount) as amt from t1
group by ---分组字段