Sql²éѯÎÊÌâ - MS-SQL Server / Ó¦ÓÃʵÀý

SQL code:
select * from (select top 200 LicensePlat,GPSDate,RowCnt from GPSVehicle v inner join GPSStatLocating s
on v.DeviceId = s.DeviceId) a pivot (max(RowCnt) for GPSDate in (20100315,20100330,20100331)) b


ͨ¹ýÉÏÃæµÄ²éѯÓï¾ä£¬ÎÒÏëµÃµ½ÏÂÃæµÄ½á¹û£¬¿ÉÊÇÀÏÊDZ¨20100315¸½½üÓÐÓï·¨´íÎó

---

SQL code ([20100315],[20100330],[20100331])) b

---

ÒýÓÃ

SQL code
select * from (select top 200 LicensePlat,GPSDate,RowCnt from GPSVehicle v inner join GPSStatLocating s
on v.DeviceId = s.DeviceId) a pivot (max(RowCnt) for GPSDate in (20100315,20100330,20¡­¡­

²»ºÃÒâ˼£¬¸Õ²ÅÒ»Ö±¸ãµ½¶¼ÍüÁË¡£Ð»Ð»°¡