select itemnr count(dateused) from table group by itemnr
Best Regards
========
| ISMAEL |
========
----- Original Message -----
From: 'Stef' [email protected] [firebird-support]
To: [email protected]
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.
i.e.
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?
Regards
Stef
[Non-text portions of this message have been removed]
