select max(count_od_qty)
from (
select count(od.qty) as count_od_qty
from odetails od, order1 o
where od.ono = o.ono
group by o.cno,od.pno
)系统一直提示
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near ')'.我也刚开始学习,请大牛指点一二。
from (
select count(od.qty) as count_od_qty
from odetails od, order1 o
where od.ono = o.ono
group by o.cno,od.pno
)系统一直提示
Msg 102, Level 15, State 1, Line 7
Incorrect syntax near ')'.我也刚开始学习,请大牛指点一二。
解决方案 »
- sql循环为每行幅值???
- 在SQL语句"select x,y from T1"中,如何保留数字字段x的小数点位数,使其在MSHFlexGrid中查看时只保留小数点后4位
- 海量数据的全文检索使用哪种数据库好?
- 怎样返回语句"select distinct * from table1"以外的记录?也就是说重复的记录
- mssql 获取数据问题。
- [DBNETLIB][ConnectionWrite (send()).]一般性网络错误。请检查网络文档
- 我想请问instead of触发器除了应用在view上外,和after触发器相比,还在哪方面应用比较广泛.
- 如何返回一个字段所有值,要去掉重复的
- update远程更新问题!!!
- 多关键词模糊查询问题
- 编写SQL数据库代码
- 如何得到某条记录的相邻5条记录?
select max(count_od_qty)
from (
select count(od.qty) as count_od_qty
from odetails od, order1 o
where od.ono = o.ono
group by o.cno,od.pno
) a