5,392
社区成员
发帖
与我相关
我的任务
分享怎样在ADODataSet中实现GROUP BY
为什么我在CommandText中输入select * from table group by name;Delphi 报错没有GROUP BY，怎么办？谢谢。
...全文
请发表友善的回复…
发表回复
jaunmai 2003-06-23
- 打赏
- 举报
select name from table group by name
DWGZ 2003-06-23
- 打赏
- 举报
你要Group By 什么呀
SELECT keyfield, 聚集函数 FROM yourtable
如
select name, sum(yourcalcfield) from table group by name
select name, avg(yourcalcfield) from table group by name
select name, count(yourcalcfield) from table group by name
SELECT keyfield, 聚集函数 FROM yourtable
如
select name, sum(yourcalcfield) from table group by name
select name, avg(yourcalcfield) from table group by name
select name, count(yourcalcfield) from table group by name
jaunmai 2003-06-23
- 打赏
- 举报
select * from table where name group by name order by name
foundAnswer 2003-06-23
- 打赏
- 举报
只有用ADOQUERY控件才可以吗？
WWWWA 2003-06-23
- 打赏
- 举报
要在ADOQUERY中设置
