Pb7.0 I checked many examples, it is can query the same record and a specific condition,
I want to check all records between two conditions, can be achieved?
How to write code?
Thank you
CodePudding user response:
Statistics from 20081005 to 20081008, for example) the sum of the gap between the:Select the convert (varchar (10), the date, 120), date, sum (col)
The from TB
Where the date & gt;='2008-10-05' and the date & lt;
='2008-10-08'Group by the convert (varchar (10), the date, 120)