Skip to content

Instantly share code, notes, and snippets.

@sqlparser
Created April 8, 2014 07:10
Show Gist options
  • Save sqlparser/10098815 to your computer and use it in GitHub Desktop.
Save sqlparser/10098815 to your computer and use it in GitHub Desktop.
create table subquery
CREATE TABLE suppliers
AS (SELECT *
FROM companies
WHERE id > 1000);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment