Explain Codes LogoExplain Codes Logo

Sql

Postgresql query between date ranges

sql
date-range
postgresql
database-optimization

Convert Rows to columns using 'Pivot' in SQL Server

sql
pivot-engineering
sql-string
dynamic-sql

Sql Server - transactions roll back on error?

sql
transactional-anomalies
error-handling
try-catch-block

Library of Useful (Difficult) SQL scripts

sql
data-integrity
performance-optimization
sql-scripts

Mysql: Typecasting NULL to 0

sql
database-optimizations
data-analytics
null-handling

Update MySQL with if condition

sql
conditional-updates
sql-queries
database-performance

How to COALESCE for empty strings and NULL values?

sql
sql-functions
performance-optimization
best-practices

Sql Joins Vs SQL Subqueries (Performance)?

sql
join
subquery
performance

Sql Server procedure declare a list

sql
table-valued-parameters
dynamic-sql
sql-server

Combining ORDER BY AND UNION in SQL Server

sql
union
order-by
sub-queries

How do I put an 'if clause' in an SQL string?

sql
conditional-statements
subqueries
join

Is there a way to persist a variable across a go?

sql
sqlcmd
stored-procedures
dynamic-sql

How to check type of value in postgres

sql
conditional-statements
postgresql
type-checking

Sql - How do I get only the numbers after the decimal?

sql
decimal-extraction
sql-functions
data-manipulation

How to flip bit fields in T-SQL?

sql
bit-manipulation
sql-queries
performance-tips

What is the difference between GROUP BY and ORDER BY in SQL?

sql
group-by
order-by
sql-queries

Using "like" wildcard in prepared statement

sql
prompt-engineering
best-practices
performance

Handling List-types with Esqueleto

sql
database-operations
list-types
sql-queries

Mysql, Concatenate two columns

sql
join
concatenation
data-integrity

Difference between Top and Limit Keyword in SQL

sql
database-compatibility
pagination
query-performance
explain.codes / Sql