Posted on 2008-12-10 11:24
Prayer 閱讀(1081)
評論(0) 編輯 收藏 引用 所屬分類:
數(shù)據(jù)庫,SQL
select * from(
select sum(settle_num),rtrim(ins_id_cd) ins_id_cd
from tbl group by ins_id_cd
) as tmp
where ins_id_cd='11111'
必須有as tmp
通過rtrim(ins_id_cd) ins_id_cd增加一個別名