Question

sql="select * from (select username,sum(shul) as shul from jingyin group by jingsh) order by shul "

sql="select * from (select username,sum(shul) as shul from jingyin group by jingsh) order by shul "
asp ACCESS 出错
数据库

Answer 1

除了"带我信乐"说的错误外,还有一处错误,就是: 子查询中的username没有使用聚合函数或加入group by 列表.
如果要改的话,需要知道表jingyin的结构,和若干条数据.

Answer 2

select * from (select username,sum(shul) as shul from jingyin group by jingsh)
要加个别名就行了
select * from (select username,sum(shul) as shul from jingyin group by jingsh) AS T
order by shul