Tag: SQL
Ryan Van Fleet
Ryan Van Fleet
14 Jan, 2020

Finding Diacritics in a Postgres Table

Recently I had the task to find all the Diacritics in a database table. I had to find an easy way to select every row that has a diacritic in the name. The solution was surprisingly simple, but a bit unintuitive. In this article, I will provide you with...
Ryan Van Fleet
Ryan Van Fleet
20 Apr, 2017

Taming of the Subselect: Three ways to use this troublesome SQL Query

Subselects can be used in many ways: filtering, retrieving specific data, and creating custom joins. Writing effective SQL using subselects, though, can be frustrating. While SQL is ubiquitous in software engineering and is a valuable skill for testing, data analysis and reporting, nowadays a lot of SQL is abstracted...