Explain Codes LogoExplain Codes Logo

Sql

Custom Order in Oracle SQL

sql
join
performance
best-practices

How to calculate age (in years) based on Date of Birth and getDate()

sql
datetime-format
date-conversion
sql-functions

Time part of a DateTime Field in SQL

sql
date-time
sql-functions
time-extraction

Mysql GROUP BY two columns

sql
subqueries
group-by
having-clause

Sql subquery with COUNT help

sql
subquery
count
performance

How to reset Postgres' primary key sequence when it falls out of sync?

sql
best-practices
sequence-reset
postgres

Add a column with a default value to an existing table in SQL Server

sql
default-values
sql-server
table-operations

Check for file exists or not in SQL Server?

sql
file-existence
sql-function
xp_fileexist

Db2 Query to retrieve all table names for a given schema

sql
db2
sql-query
database-management

Conditional WHERE clause in SQL Server

sql
conditional-where-clause
sql-performance
dynamic-sql

How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?

sql
subquery
join
data-integrity

Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot

sql
data-conversion
import-settings
data-types

Tsql DATETIME ISO 8601

sql
datetime
sql-server
performance

Mysql too many indexes?

sql
indexing-strategy
database-performance
mysql-optimization

Sql SELECT LIKE (Insensitive casing)

sql
case-insensitivity
dbms
sql-queries

What does SQL Select symbol || mean?

sql
concatenation
sql-injection
performance

How can I make SQL case sensitive string comparison on MySQL?

sql
case-sensitive-comparison
mysql-collations
sql-string-comparison

Sqlite Query in non case sensitive alphabetical order

sql
case-insensitive-ordering
sqlite-queries
database-performance

How to execute "left outer join" in SqlAlchemy

sql
left-outer-join
sqlalchemy
database-queries

How to alter a column's data type in a PostgreSQL table?

sql
data-loss
constraint-violations
indexing
explain.codes / Sql