Dharmesh Sharma

Dharmesh Sharma

  • NA
  • 905
  • 926k

How to get Current Year Data month wise

Dec 28 2011 6:48 AM
hello ,

i am not get any idea how to do

i have one table then  and i want to show data year 2011 like month wise count entry

 Res_Name      Jan  feb   mar   apr...........................................DEC

  A      1     2    3       1     .....................................................5
.
.
.
.
B        3     1   2    1   .........................................................5

and tabel is
ID  res_id    Menu     Res_name    Coment                Date
1    2             4       A                  test                    2011-12-23 16:51:07.587    5
2    2            11      A                  testing                  2011-12-24 14:23:16.050    5
3    2            11      B                  test test test test   2011-12-24 14:23:42.523    5
4    2            11      C                  test test test test    2011-12-24 14:23:57.800    3
5    2            12      D                  testeasdasdasdasd   2011-12-24 16:10:18.713    5


so i am not geting any solution i try but i am not get month wise

please give me some sql code
thanks

Answers (9)