谁会写这句SQL语句? select Date,Count(Address) from 表名 where owner='Jerry_Huang' group by Date order by Date,Time没有做过统计的字段(这里是Date)必须放在group by里 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Select Date, Count(Address), Owner From yourTable Group By Date, Owner Order by Date 那假如我还要再多显示一个字段( Pwd )呢?巴顿,我想同一天就按照时间Time排序 Select Date, Count(Address), Owner From yourTable Group By Date, Owner Order by Date, timer Select [Date], Count(Address), Owner From yourTable Group By [Date], Owner Order by [Date], TimerDate是关键字,以后不要用此作字段名!否则都要加上[]。 Select [Date], Count(Address), Owner,Pwd From yourTable Group By [Date], Owner Order by [Date], TimerDate是关键字,以后不要用此作字段名!否则都要加上[]。 一个很急的问题!!! 年底最后一问:用VB读DBF数据库中SQL语句的如何选择符合时间条件的记录????指教 怎么引用自定义控件中的TEXT的文本,大家帮帮忙吧 紧急求助,VB4.0 16bit 通过ODBC 连接Access 软件又买出了一套,散分庆祝!耶! vb 6.0 到底可以做些什么?不可以做些什么? 包含MSCOMM32.OCX 的库文件是哪个? 在win98+vb6中能否做出象windowsXP中漂亮的菜单? 如何在文本框中正确显示中文 如何打开文件 如何断开ADO连接? 急!如何實現圖形的無損失縮小.
Group By Date, Owner
Order by Date
Group By Date, Owner
Order by Date, timer
Group By [Date], Owner
Order by [Date], TimerDate是关键字,以后不要用此作字段名!否则都要加上[]。
Group By [Date], Owner
Order by [Date], TimerDate是关键字,以后不要用此作字段名!否则都要加上[]。