Table A
The column of
ID name weight time
1 cucumber 5 2014-12-15 15:45:00. 000
1 pineapple 7.1 2014-12-15 16:00:00. 000
2 2.3 2014-12-15 15:45:00 cucumber. 000
1 eggplant 4.2 2014-12-15 16:30:23. 000
2 beans 3.1 2014-12-15 16:30:23. 000


Can select the ID of 1 or 2, according to the time the query a "name" of the total weight,
Can distinguish between ID and can be applied to the data detailed list every day,

Such software should use what to write, the younger brother novice, can have a look at the SQL data slightly, to a piece of software programming,
Wish you a great god can be give directions,

CodePudding user response:

Is there a great god for help

CodePudding user response:

This post, a great god is not to patronize, Delphi + Ado controls, TadoQuery control fully competent, baidu in our own testing method of use, if there is something wrong with the test coming up in the post code...

CodePudding user response:

Requirement, can determine the concrete, to help,

CodePudding user response:

Is a simple query documents, as for the total, can be directly set table properties,

CodePudding user response:

This is very simple to connect to the database for several SQL statements

CodePudding user response:

Is the thing, write SQL:

CodePudding user response:

Indeed a great god will not tube

Select ID, name, convert (char (4), year) (time) + '-' + convert (char (2), month (time)) + '-' + convert (char (2), day (time)) as the date, the sum (weight)

the from list AGroup by ID, name, date

CodePudding user response:

The where (the time you set the time between the beginning and you set the time end) and the name of the name=you