Explain Codes LogoExplain Codes Logo

Sql

Sqlite DateTime comparison

sql
date-comparison
datetime-functions
error-handling

List of special characters for SQL LIKE clause

sql
like-clause
wildcards
database-collation

Replacing NULL with 0 in a SQL server query

sql
null-handling
performance
aggregate-functions

How to generate a new Guid in stored procedure?

sql
guid
stored-procedure
best-practices

Mysql SELECT only not null values

sql
nulls
database-normalization
queries

How to use multiple CTEs in a single SQL query?

sql
ctes
query-optimization
best-practices

Possible to perform cross-database queries with PostgreSQL?

sql
cross-database
dblink
performance-optimization

How can I create a copy of an Oracle table without copying the data?

sql
table-copy
data-integrity
performance

Sql NVARCHAR and VARCHAR Limits

sql
nvarchar
varchar
dynamic-sql

How to order by column A and then by column B?

sql
order-by
where-clause
troubleshooting

Mysql Results as comma-separated list

sql
group-concat
sql-injection
string-aggregation

Mysql: Get character-set of database or table or column?

sql
character-set
best-practices
data-migration

How to calculate percentage with a SQL statement

sql
percentage-calculation
window-functions
data-accuracy

Combining UNION and LIMIT operations in MySQL query

sql
union
limit
pagination

Using a Conditional Update Statement in SQL

sql
conditional-update
case-statement
best-practices

Mysql, better to insert NULL or empty string?

sql
null
empty-string
data-integrity

Select statement to find duplicates on certain fields

sql
duplicates
subqueries
window-functions

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints

sql
constraint-violation
data-integrity
debugging

How to combine date from one field with time from another field - MS SQL Server

sql
datetime
performance
readability

Right query to get the current number of connections in a PostgreSQL DB

sql
postgresql
database
connections
explain.codes / Sql