Kalvad
  • Home
  • Website
Subscribe

order

A collection of 1 post
SQL - Is Your Sort Order Deterministic?
A classic example of S.E.P. (Somebody Else’s Problem)
SQL

SQL - Is Your Sort Order Deterministic? A classic example of S.E.P. (Somebody Else’s Problem)

A Forgettable Rule One of the first things you forget about SQL databases is that an un-ordered query can return results in any order, i.e. a non-deterministic sort order.  Moreover, the order is not guaranteed each time you execute the query. Here is an example of a query with
Apr 4, 2022 — 5 min read
Kalvad © 2023
Powered by Ghost