Question

gridview怎么求一行合计有具体的写法吗？

Answer 1

SELECT branch_no, agent_no, name, pol_code, premt,date
FROM t1
WHERE (date = @date) AND (branch_no LIKE @branch_no) AND (LEFT (agent_no, 5) LIKE @tjagent_no)
union all
select '','','','合计:',sum(premt),'' from t1
WHERE (date = @date) AND (branch_no LIKE @branch_no) AND (LEFT (agent_no, 5) LIKE @tjagent_no