Common table expression

• Snippet
• SQL
• 2 blanks to fill

WITH Name AS (
  SELECT 
  FROM Table
)
SELECT *
FROM Name;

About this template

WITH query.

Category

Code snippets

Pack

SQL

Type

Snippet, a short message

Asks for

Name, Table

Use it anywhere you write: email, chat, a document or a support tool. If you send it often, save the finished text as a snippet in ClipBuddy and paste it again from your clipboard history with ⌘⇧V.

WITH {{Name}} AS (
  SELECT {{cursor}}
  FROM {{Table}}
)
SELECT *
FROM {{Name}};

More code snippets templates

• Insert row Snippet Insert values.
• Update rows Snippet Update with where.
• Delete safely Snippet Check first, then delete.
• Create table Snippet New table.
• Add index Snippet Speed up lookups.
• Add column Snippet Alter table.

See all 268 code snippets templates