Hi,
I have some problem executing a sql query in MySQL. I have a table consisting of 2 columns, date and amount. I am trying to retrieve a summary of total amount for a particular month.
Here's the psuedo code:
SELECT SUM(amount)
from Table
Where month = july/2000
What's the correct syntax for MySQL ? Thanks a lot in advance.
I have some problem executing a sql query in MySQL. I have a table consisting of 2 columns, date and amount. I am trying to retrieve a summary of total amount for a particular month.
Here's the psuedo code:
SELECT SUM(amount)
from Table
Where month = july/2000
What's the correct syntax for MySQL ? Thanks a lot in advance.