我有一张表,结构如下
date equipment max min avg
1 a 5 2 3
1 b 5 0 5
1 c 6 1 8
2 .....
2 .......求一条mysql语句使查询结果显示成
date max equipment min equipment maxavg equipment minavg equipment
1 5 a 0 b 8 c 3 a
1 5 a - - - - - -
2 .... 能不能实现啊 求高手显身啊!
date equipment max min avg
1 a 5 2 3
1 b 5 0 5
1 c 6 1 8
2 .....
2 .......求一条mysql语句使查询结果显示成
date max equipment min equipment maxavg equipment minavg equipment
1 5 a 0 b 8 c 3 a
1 5 a - - - - - -
2 .... 能不能实现啊 求高手显身啊!
1、这里是MS-SQL板块,我不会MYSQL。
2、行列转换规则我没有看明白。
2、上面的3行1开头的数据,下面为什么变成2行了?
3、equipment 字段上面1对应的是abc 下面为什么是abca?
date max equipment min equipment maxavg equipment minavg equipment
1 6 a 0 b 8 c 3 a是不是这样的?
date max equipment min equipment maxavg equipment minavg equipment
1 6 c 0 b 8 c 3 a是这样的吧