Explain Codes LogoExplain Codes Logo

Sql

How to Check for is Not Null and is Not Empty String in SQL Server?

sql
best-practices
performance
data-variants

Mysql Select rows on first occurrence of each unique value

sql
window-functions
mysql-8
performance

Sum of grouped COUNT in SQL Query

sql
sql-queries
group-by
window-functions

Only show hours in MYSQL DATEDIFF

sql
timestamp
unix_timestamp
timediff

Duplicate key on write or update?

sql
data-integrity
database-design
constraint-naming

How to change the default collation of a table?

sql
database-management
collation-alteration
mysql

Check if two "select"s are equivalent

sql
join
database
sql-standards

Get Table and Index storage size in SQL Server

sql
performance-tuning
storage-management
database-optimization

How to convert integer to decimal in SQL Server query?

sql
data-type-precedence
precision-control
error-handling

Mysql count group by having

sql
subqueries
sql-aggregation
group-by

Should I set max pool size in database connection string? What happens if I don't?

sql
database-connection
performance-optimization
best-practices

What's a PostgreSQL "Cluster" and how do I create one?

sql
database-management
postgresql-configuration
cluster-management

How to add a column and make it a foreign key in a single MySQL statement?

sql
foreign-key
mysql-manipulation
database-design

Mysql - How to grant read only permissions to a user?

sql
grant-permissions
mysql-privileges
database-security

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
explain.codes / Sql