mirror of
https://github.com/tursodatabase/libsql.git
synced 2024-12-15 08:39:46 +00:00
20 lines
369 B
Plaintext
20 lines
369 B
Plaintext
|
|
CREATE TABLE t1(x, y);
|
|
INSERT INTO t1 VALUES(1, 2);
|
|
CREATE VIEW v1 AS SELECT * FROM (
|
|
WITH x1 AS (SELECT y, x FROM t1)
|
|
SELECT * FROM x1
|
|
);
|
|
|
|
|
|
SELECT * FROM v1
|
|
|
|
|
|
CREATE VIEW v3 AS SELECT * FROM main.t1;
|
|
WITH t1(a, b) AS ( SELECT 3, 4 ) SELECT * FROM v3;
|
|
|
|
|
|
CREATE VIEW v2 AS SELECT * FROM t1;
|
|
WITH t1(a, b) AS ( SELECT 3, 4 ) SELECT * FROM v2;
|
|
|