CREATE VIEW myview AS SELECT * FROM mytable WHERE x > 12; SELECT * FROM myview; SELECT * FROM (SELECT * FROM mytable WHERE x > 12) AS myview;