我有一个表结构如下:
field1
field2
field3
date
我想得到如下的报表:
————————————————————————————————
| date1 | date2 | date3
field1| field2 field3 | field2 field3 | field2 field3
---------------------------------有什么办法吗?
field1
field2
field3
date
我想得到如下的报表:
————————————————————————————————
| date1 | date2 | date3
field1| field2 field3 | field2 field3 | field2 field3
---------------------------------有什么办法吗?
select field1,field2+field3 as a2,field2+field3 as a3
| date1 | date2 | date3 ...
field1| field2 |field3 | field2 |field3 | field2 |field3 ...
---------------------------------
^_^
| date1 | date2 | date3 ...
field1| field2 |field3 | field2 |field3 | field2 |field3 ...
---------------------------------
^_^
| date1 | date2 | date3 ...
field1| field2 |field3 | field2 |field3 | field2 |field3 ...
| field2 |field3 | field2 |field3 | field2 |field3 ...
field1| field2 |field3 | field2 |field3 | field2 |field3 ...
---------------------------------^_^