Select with filter

• Snippet
• SQL
• 5 blanks to fill

SELECT *
FROM Table
WHERE Condition
ORDER BY Column DESC
LIMIT 100;

About this template

Basic query.

Category

Code snippets

Pack

SQL

Type

Snippet, a short message

Asks for

Columns, Table, Condition, Column, Limit

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.

SELECT {{Columns=*}}
FROM {{Table}}
WHERE {{Condition}}
ORDER BY {{Column}} DESC
LIMIT {{Limit=100}};

More code snippets templates

• Count by group Snippet Group and count.
• Find duplicates Snippet Rows appearing more than once.
• Inner join Snippet Join two tables.
• Left join missing rows Snippet Rows with no match.
• Last N days Snippet Recent rows.
• Daily totals Snippet Group by day.

See all 268 code snippets templates