Explain Codes LogoExplain Codes Logo

Sql

Sql query to group by day

sql
group-by
indexing
date-functions

In Postgres, how do you restrict possible values for a particular column?

sql
check-constraints
enum-types
triggers

Is there an elegant way to Invert a Bit value in an SQL insert Statement?

sql
bit-inversion
null-handling
performance

Get table column names in MySQL?

sql
column-names
wildcards
php

How do I convert from BLOB to TEXT in MySQL?

sql
blob
conversion
mysql-workbench

Oracle SQL - Date greater than statement

sql
date-format
nls-date-language
add-months

Mysql number of items within "in clause"

sql
in-clause
performance
optimization

Min/max vs ORDER BY and LIMIT

sql
performance
indexing
query-optimization

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

sql
mysql
socket-connection
troubleshooting

Select INTO in MySQL

sql
create-table
insert-into
performance

Left join without duplicate rows from the left table

sql
left-join
outer-apply
distinct

How do I limit the number of rows returned by an Oracle query after ordering?

sql
pagination
offset
fetch

Increment value in MySQL update query

sql
increment
sql-injection
transactions

Mysql very slow for alter table query

sql
alter-table
performance
best-practices

How to check DB2 version

sql
db2
version-check
sql-syntax

How do I get textual contents from BLOB in Oracle SQL?

sql
blob-extraction
character-set
oracle-19c

Optimal way to concatenate/aggregate strings

sql
string-aggregation
performance
best-practices

Does PostgreSQL support "accent insensitive" collations?

sql
unaccent
full-text-search
collations

How to do a count on a union query

sql
union
count
subquery

How do I change db schema to dbo

sql
schema-change
database-backup
best-practices
explain.codes / Sql