Explain Codes LogoExplain Codes Logo

Sql

Empty array as PostgreSQL array column default value

sql
array-defaults
postgresql
database-infrastructure

Sql Performance UNION vs OR

sql
performance
best-practices
indexing

Extract Month and Year from SQL DATE

sql
date-extraction
sql-functions
date-manipulation

What kind of datatype should one use to store hashes?

sql
data-integrity
storage-optimization
hash-functions

Using the DISTINCT keyword causes this error: not a SELECTed expression

sql
distinct
order-by
sql-best-practices

Transfer data between databases with PostgreSQL

sql
database-migration
postgresql
data-transfer

How to Select Every Row Where Column Value is NOT Distinct

sql
subqueries
sql-performance
best-practices

Better techniques for trimming leading zeros in SQL Server?

sql
best-practices
performance
sql-server

Use LIKE %..% with field values in MySQL

sql
text-search-operations
sql-joins
performance-optimisation

Group MySQL query by 15 min intervals

sql
unix-timestamp
mysql-performance

Alter DATABASE failed because a lock could not be placed on database

sql
database-administration
sql-server
lock-issues

Filter Table Before Applying Left Join

sql
subquery
ctes
index-optimization

What is a good reason to use SQL views?

sql
data-abstraction
database-management
sql-views

Find a string by searching all tables in SQL Server

sql
sql-injection
database-optimization
sql-server

Sql, Auxiliary table of numbers

sql
performance
best-practices
sql-server

Mysql: Select DISTINCT / UNIQUE, but return all columns?

sql
distinct
group-by
sql-performance

Are PostgreSQL column names case-sensitive?

sql
database-migration
sql-standards
best-practices

Mysql: GROUP_CONCAT with LEFT JOIN

sql
join
groupby
performance-tuning

Having issues with a MySQL Join that needs to meet multiple conditions

sql
join
best-practices
performance

How to do select from where x is equal to multiple values?

sql
subqueries
join
performance
explain.codes / Sql