Home > database >  With PB7.0 can realize locate all of the data between the two date?
With PB7.0 can realize locate all of the data between the two date?

Time:10-02

With PB7.0 can realize locate all of the data between the two date?

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)
  • Related