从结果集中筛选 select sum(total) from select count(*) as total from tvisted group by userid用这句话查询时总是说“在关键字 'select' 附近有语法错误。”不知道为什么 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select sum(total) from (select count(*) as total from tvisted group by userid)a select sum(total) as total from (select count(*) as total from tvisted group by userid) t 我晕,你不就想查:select count(*) from tvisted 吗? 我晕,你不就想查:select count(*) from tvisted 吗?当然不是啦,呵呵 select sum(total) as total from (select count(*) as total from tvisted group by userid) t这个和我原来犯了一样的错。 简单的查询语句优化,只要你进来就可以拿分! 日志文件 哪位能讲讲CursorLocation 呀 谢谢! Sql Bom表展开(只显示明细并算其使用数量) 疑难问题请教!!!!! mssql2005远程导入数据主键信息丢失,知道的帮个忙 分时间段查询 有无办法减小VFP6的两个DLL文件尺寸 构建网络数据库,请给点见意!UP有分!!!多谢!! 多表联合查询的一个问题 怎样向控件中插入数据?
(select count(*) as total from tvisted group by userid)a
select count(*) from tvisted
吗?
select count(*) from tvisted
吗?当然不是啦,呵呵