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: Generic SQL

Articles about standard SQL features that will work on the most common DBMSs, and articles that include information about several DBMSs.

Find rows that (don’t) contain a value from a list

How to find rows that contain, or don’t contain, a value from a list. The list may be written in the query, or stored in a table.

Continue reading Find rows that (don’t) contain a value from a list
Published July 25, 2021
Categorized as Generic SQL Tagged level-beginner

Find rows that have a match in another table

How to SELECT rows from table A that have, or don’t have, a match in table B. While doing this, we’ll keep performance in mind.

Continue reading Find rows that have a match in another table
Published July 25, 2021
Categorized as Generic SQL Tagged level-intermediate

Find the maximum text length in a column

How to get the length of the longest text in a column. Including Db2 specific syntax.

Continue reading Find the maximum text length in a column
Published July 24, 2021
Categorized as Db2, Generic SQL, Informix, MariaDB, Oracle, PostgreSQL, SQL Server Tagged level-beginner

Grouping rows by a range of values

GROUP BY allows us to group identical values to aggregate data. What is not obvious is that it can be easily used to group values that belong to the same range, as well.

Continue reading Grouping rows by a range of values
Published July 24, 2021
Categorized as Generic SQL, Informix Tagged level-intermediate

Create a cross-table unique ID

Most tables are created with a unique, progressive ID. But how to create an ID whose values are unique across multiple tables? For example, if value 1 is in table A, it must not be in table B.

Continue reading Create a cross-table unique ID
Published July 23, 2021
Categorized as Db2, Generic SQL, Informix, MariaDB, Oracle, PostgreSQL, SQL Server Tagged level-intermediate

Find invalid emails

How to select invalid email addresses from a column. How to reject attempts to insert invalid emails into a column.

Continue reading Find invalid emails
Published July 23, 2021
Categorized as Generic SQL Tagged level-beginner

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

Find values (not) in a given range

How to use the special SQL syntax to select rows with values in a given range, or outside of it. How to deal with bounds in a reversed order.

Continue reading Find values (not) in a given range
Published July 22, 2021
Categorized as Generic SQL Tagged level-beginner

Count a table rows

How to count a table rows, a table distinct rows, a column values, missing values, etc.

Continue reading Count a table rows
Published July 22, 2021
Categorized as Generic SQL Tagged level-beginner

Posts navigation

Newer posts Page 1 … Page 3
  • Twitter
  • Email
SQL Bits
Proudly sponsored by Vettabase.