Skip to content

SQL Bits

You're here to find quick SQL recipes.

  • Home
  • Topics
    • Generic SQL
    • PostgreSQL
    • MariaDB
    • MySQL
    • Oracle
    • SQL Server
    • Db2
    • Informix
    • SQLite
  • Advertising
  • Write
  • About

Category: SQLite

Aggregate data that match a condition

How to aggregate data that match a given condition. How to perform different aggregations of data that match different conditions, in a single query. Includes convenient SQLite shortcuts.

Continue reading Aggregate data that match a condition
Published July 27, 2021
Categorized as Generic SQL, SQLite Tagged level-intermediate

Aggregate a column data

How to get statistical data from a column in standard SQL. In particular it shows how to get the minimum, maximum, average values, and the standard deviation.

Continue reading Aggregate a column data
Published July 22, 2021
Categorized as Generic SQL, SQLite Tagged level-beginner
  • Twitter
  • Email
SQL Bits
Proudly sponsored by Vettabase.