Question Locked

sql query to disply all month names

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
have a simple table containing order number, order date, cd number, cd title etc. I have imported 5000 records and need to analyse the data for trends. I need to create a query that will extract and list month names and the number of orders for each month. The closest I have got to this has resulted in a parameter query which I do not want. I want to view all months. if there is no orders for a pirticular month the count should be displyed as 0. Can anyone help?

2 replies

by shady108

select * from table where orderdate=january and ordernumber>0

ooooooooo i cant remember been 10 years since i did any sql! lol :D

This discussion is closed to new replies.