小計 合計

StringBuilder strSql = new StringBuilder();strSql.Append("select * from ( ");strSql.Append("select id,decla_id,customs_broker,unstuffing_group,tallyman,customer,customs_officer,ruku_time,ruku_way,ruku_storage,ruku_shell,goods_name,num,single_num,remark ");strSql.Append(" FROM dt_ruku "); strSql.Append(" union all select min(id), decla_id,null,null,null,null,null,null,null,null,null,goods_name='小計',sum(num)num,null,null from dt_ruku ");strSql.Append(" group by decla_id ) t ");if (strWhere.Trim() != ""){strSql.Append(" where " + strWhere);} strSql.Append(" order by decla_id ,case goods_name when '小計' then 2 else 1 end ");return DbHelperSQL.Query(strSql.ToString()); order by case when bugosstate=0 then 'severity desc' else 'thedate desc' end 實現不同的 bugosstate = 0的時候 按 severity 排序 bugosstate<>0的時候 按thedate排序

小計 合計 -統計? ?? http://www.cnblogs.com/zengxiangzhan/archive/2010/01/03/1638155.html

轉載于:https://www.cnblogs.com/LifeKingcn/archive/2012/12/21/2827603.html

總結

以上是生活随笔為你收集整理的sql code的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。