Subject Re: [firebird-support] QUERY QUESTION
Author Ismael L. Donis Garcia
select itemnr count(dateused) from table group by itemnr
Best Regards
----- Original Message -----
Sent: Thursday, March 02, 2017 11:36 AM
Subject: [firebird-support] QUERY QUESTION


Good day,

I have a question for you SQL boffins, how can I query a table to get the
count of consecutive days found ?

A Table contains rows with dates where an item(s) has been added for every
day this item was used.


itemnr dateused

abc 2017/02/01

abc 2017/02/02

abc 2017/02/25

abc 2017/02/25

abc 2017/02/25

abc 2017/02/26

abc 2017/02/27

abc 2017/02/28

abc 2017/03/01

abc 2017/03/02

The result from above sample should be 6 as there is a break between
2017/02/02 and 2017/02/25?



[Non-text portions of this message have been removed]