???? select [ Field1,Field2,] sum(Field3) NewFieldName
from Table
[ where ....]
group by [ Field1,Field2 ]
[ having sum(Field3) >= xxx ] select sum(score) total
from stu_score select stu_no,sum(score) stu_total
from stu_score
group by stu_no是这个吗?
from Table
[ where ....]
group by [ Field1,Field2 ]
[ having sum(Field3) >= xxx ] select sum(score) total
from stu_score select stu_no,sum(score) stu_total
from stu_score
group by stu_no是这个吗?
解决方案 »
- 疑是高难度问题,请VC和Delphi双料高手不吝赐教,千万不要飘过……
- 使用hjy2:=inttohex(hjy,4);方法假设得到2个(hjy2):1A 01 和 DE 21,那能推出这2个之前的10进制相差多少吗?
- 怎么设置mysql4.01的字符集
- 再问个简单问题
- messagedlg函数问题!
- 欢迎各位高人捧场------.NET和WIN32大讨论.
- webbrowser中图片显示?
- 控制小数显示
- SQLite和Berkeley DB 连接delphi
- 请问如何用控件SOCKET传数据库的数据呢?
- 在DELPHI中如何读取Excel 97 或2000工作表.
- 用什么方法在TtreeView中实现数据库的树状表示???
begin
Close;
SQL.Clear;
SQL.Add('select * from dingdan');
SQL.Add('where date3=today');
// SQL.Add('group by sum(zongji)');
try
Open;
except
execsql
end;
end;
begin
Close;
SQL.Clear;
SQL.Add('select sum(zongji) from dingdan');
>> SQL.Add('where date3=today'); 这里改成相应的条件
try
Open;
except
>> execsql open了不用再execute了
end;
end;
哪今月和今年有没有函数代表哪?还是用这一种办法呢!
var
Present: TDateTime;
Year, Month, Day: Word;
begin
Present:=date1.Table1Date3.Value;
DecodeDate(Present, Year, Month, Day);
end;
I done it你看看这样行不行!
var
i:string;
begin
i:=datetostr(date);
with date1.Query2 do
begin
Close;
SQL.Clear;
SQL.Add('select sum(zongji) from dingdan');
SQL.Add('where date3=:a');
ParamByName('a').asdatetime:=strtodate(i); // SQL.Add('group by sum(zongji)');
try
Open;
except
execsql
end;
end;
if date1.Query2.FindFirst then
//form3.QuickRep1.Print
else
begin
application.MessageBox('对不起今天你没有输入记录','警告',0);
end;
还有一个问题哪今月和今年有没有函数代表哪?
I done it你看看这样行不行!
var
i:string;
begin
i:=datetostr(date);
with date1.Query2 do
begin
Close;
SQL.Clear;
SQL.Add('select sum(zongji) from dingdan');
SQL.Add('where date3=:a');
ParamByName('a').asdatetime:=strtodate(i); // SQL.Add('group by sum(zongji)');
try
Open;
except
execsql
end;
end;
if date1.Query2.FindFirst then
//form3.QuickRep1.Print
else
begin
application.MessageBox('对不起今天你没有输入记录','警告',0);
end;
还有一个问题哪今月和今年有没有函数代表哪?你的oicq号码能给我吗?
SQL.Add('where date3>=:a and date3<=:b');
ParamByName('a').asdatetime:=strtodate(i);
ParamByName('b').asdatetime:=strtodate(i);
查当月
DecodeDate(date1, Year, Month, Day);
SQL.Add('where date3>=:a and date3<=:b');
ParamByName('a').asdatetime:=encode(year,month,1);
date2:=incmonth(date);
decodedate(date2,yy,mm,dd);
date2:=encode(yy,mm,1); //得到下个月一号
ParamByName('b').asdatetime:=date2-1;
当年
DecodeDate(date1, Year, Month, Day);
SQL.Add('where date3>=:a and date3<=:b');
ParamByName('a').asdatetime:=encode(year,1,1);
ParamByName('a').asdatetime:=encode(year,12,31);