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
|
| 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
|
| 87
|
|
|
Please help.
Thanks a ton in advance.