0

I am trying to display this SQL query in a table.

String query = "SELECT COUNT(`appointmentId`),EXTRACT(MONTH FROM `start`) FROM `appointment` WHERE YEAR(start) = '" + year + "' GROUP BY EXTRACT(MONTH FROM `start`)";

Unfortunately I cannot alter the database. I am trying to list the total appointments per month on a table or perhaps a TextArea. Any ideas please?

Thanks!

Edited by Phantess

2
Contributors
2
Replies
18
Views
1 Month
Discussion Span
Last Post by Phantess
0

Thank you very much! That helped alot! I really appreciate it!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.