Experience Have done application programming as well as some installation and administration mostly with MySQL for web servers and site development and also with IMS and DB2 on legacy systems in the past.
Expert: Marty Landman Date: 2/15/2007 Subject: SQL date query question
Question Hello, I have a database which has a list of products, then a list of the price of each product, and then a list of dates they were sold (D/M/YYYY).
I would I go about writing a query that would give me a list of months only and the total price of the products sold in that month. For example what is the total amount of money made in the month of February.
The variables are productName, price and transactionDate. And the table name is MAIN. I don't need to display the productName.
Answer TJ,
select sum(price) from _________ where transactionDate like '__/02/____';
