MS Access Query does not differentiate hiragana and katakana with standard equality operator – This article will take you through […]
Author: Josh
Subtracting one row of data from another in SQL
Subtracting one row of data from another in SQL – This article will take you through the common SQL errors […]
Show a one to many relationship as 2 columns – 1 unique row (ID & comma separated list)
Show a one to many relationship as 2 columns – 1 unique row (ID & comma separated list) – This […]
Postgresql insert if not exists
Postgresql insert if not exists – This article will take you through the common SQL errors that you might encounter […]
How to create simple fuzzy search with PostgreSQL only?
How to create simple fuzzy search with PostgreSQL only? – This article will take you through the common SQL errors […]
Auditing SQL Server data changes
Auditing SQL Server data changes – This article will take you through the common SQL errors that you might encounter […]
Rails includes with conditions
Rails includes with conditions – This article will take you through the common SQL errors that you might encounter while […]
How do I flip a bit in SQL Server?
How do I flip a bit in SQL Server? – This article will take you through the common SQL errors […]
Filtering out duplicate subsequent records in a SELECT
Filtering out duplicate subsequent records in a SELECT – This article will take you through the common SQL errors that […]
Calculate average, variance and standard deviation of two numbers in two different rows/columns with sql / PHP on specific dates
Calculate average, variance and standard deviation of two numbers in two different rows/columns with sql / PHP on specific dates […]