PostgreSQL do block, json query, dynamic SQL, crosstab 实现动态行转列透视表 pivot table
CREATE TABLE Students ( StudentID INT PRIMARY KEY, FirstName TEXT, LastName TEXT);INSERT INTO StudentsVALUES (1, 'Anne', 'Lee'),(2, 'Sarah', 'Christian'),(3, 'John', 'Smith');CREATE TABLE ...
原创
2019-03-06 11:48:10 ·
344 阅读 ·
0 评论