hi all,
I have a problem
If I have a table as below
| TRANSACTION_DATE | ITEM_CODE | ITEM_DESCRIPTION | ITEM_TYPE | AMOUNT |
|---|
| 1/30/2014 8:53:06 AM | 1001 | coconut | food | 2000 |
| 1/30/2014 8:53:06 AM | 1002 | peanut | food | 3000 |
| 1/30/2014 8:53:06 AM | 2002 | donat | food | 1000 |
| 1/30/2014 8:53:06 AM | 2003 | cryspy | food | 5000 |
| 1/30/2014 8:53:06 AM | 5001 | cola | drink | 3000 |
| 1/30/2014 8:53:06 AM | 5002 | pepsy | drink | 3000 |
| 1/30/2014 8:53:06 AM | 5003 | isotonic | drink | 3000 |
how can I get the number of records based ITEM_TYPE 'Food' which item_code it begins with the number '2 'which then I gave the name' X '.
and also how can I get the number of records that his item_description 'Drink' and then I gave the name 'Y'
thanx all for your help..