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