Riddhi Valecha

Riddhi Valecha

  • 429
  • 3.2k
  • 396.9k

Issue in forming an SQL Query

Jan 1 2015 12:53 AM
Hi all...

I have to form a sql query.

My requirement is -
I have a table -
ID
Date
Value
1
2014-09-01
4
2
2014-11-09
5
3
2014-08-06
66
4
2014-08-09
55
5
2014-08-08
78
6
2014-12-01
79
7
2014-12-13
90
8
2014-11-11
92
9
2014-12-11
87
10
2014-09-09
34

ID- Primary Key, Auto Increment.
I want a result like this -
Date
Value
September-2014
4
September-2014
34
November-2014
5
November-2014
92
August-2014
66
August-2014
55
August-2014
78
December-2014
79
December-2014
90
December-2014
87



Please help.

Thanks a ton in advance.

Answers (4)