行转列失败了，。。。。。。。。。。。。

Question

select * from AttendanceInfo pivot(max(AttendanceID) for cast(FaceTime as nvarchar(30)) in( [FirstTime],[LastTime]))a
好像报错 “（”有错误，

Answer 1

MySQL行转列、列转行常用函数用法介绍 http://www.data.5helpyou.com/article388.html