I am trying to come up with an oracle sql query to get parts purchase in February 2007. Review InvoiceExample table below.
Table Name: InvoiceExample
InvoiceID | InvoiceDate | PartsPurchase |
1 | 2/4/2007 | Bike |
2 | 2/5/2006 | Piano |
3 | 2/6/2007 | Car |
4 | 2/7/2007 | House |
The result is:
1 | 2/4/2007 | Bike |
3 | 2/6/2007 | Car |
4 | 2/7/2007 | House |