sql 行转列
pek sha 2009-05-11 590
pek wnz 2009-05-11 1050
sha pek 2009-05-11 1040
pek sha 2009-05-12 590
pek wnz 2009-05-12 1050
-------------------------------------------
以上数据能查出下面的结果(日期不是固定的,可能还有其他日期)!!!
startcity endcity 2009-05-11 2009-05-12
---------------------------------------------
pek sha 590 590
pek wnz 1050 1050
sha pek 1040 -