next query
Posted: Tue Dec 08, 2009 2:46 pm
Hi all,
I need help on performing queries. Try to explain.
Ive a db_table with following fields: date, type, name.. where name is a subgroup of type.
On 01/01/200x there are some data so I can start from there to do my search an operations.
Then during the year some new name of the same type as the one of already presnt records, is inserted in db_table and from that point on there are some records with those characteristics.
What I cant do is to find the "start point" of each new name.
Hope this is more clear
I need help on performing queries. Try to explain.
Ive a db_table with following fields: date, type, name.. where name is a subgroup of type.
On 01/01/200x there are some data so I can start from there to do my search an operations.
Then during the year some new name of the same type as the one of already presnt records, is inserted in db_table and from that point on there are some records with those characteristics.
What I cant do is to find the "start point" of each new name.
Hope this is more clear
Code: Select all
date | type | name
01-01| foo | AA
01-01| foo | AB
01-01! foo | AC
02-01| foo | AA
02-01| foo | AB
02-01! foo | AC
[...]
05-02| foo | AA
05-02| foo | AB
05-02! foo | AC
[color=#FF0000][b]05-02| foo | BA[/b][/color]
07-02| foo | AA
07-02| foo | AB
07-02! foo | AC
07-02| foo | BA
[...]
15-03| foo | AA
15-03| foo | AB
15-03! foo | AC
15-03| foo | BA
[color=#4080FF][b]15-03| foo | CA[/b][/color]
15-03| foo | AA
15-03| foo | AB
15-03! foo | AC
15-03| foo | BA
15-03| foo | CA