TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Dharmesh Sharma
NA
905
927.1k
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
Reply
Answers (
9
)
Recursion
Update query