1
Answer

Oracle Sql Query by month and year

David Smith

David Smith

10y
889
1
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
Answers (1)