Posted on: 7/15/2012 12:46:35 PM | Views : 274

I have an issue wid query
select count(docid) as  docid,date from cntr_kio_docid group by date
im getting result as below
docid  date
7         01/06/2012
8        02/06/2012
8        02/07/2012 --->here it is mixing 7th month also but i need this 7th month should come after all dates finished for 6th month...
15      03/06/2012
17      03/07/2012

Here Its grouping by datesequence but not by month ..how can i group by date & month..Please help
...

Go to the complete details ...