sql query to disply all month names - TechRepublic
Question
January 23, 2008 at 11:22 PM
kiran.kvk77

sql query to disply all month names

by kiran.kvk77 . Updated 18 years, 4 months ago

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?

This discussion is locked

All Comments