Explain Codes LogoExplain Codes Logo

Sql

Cross JOIN vs INNER JOIN in SQL

sql
inner-join
cross-join
performance

Reset auto increment counter in postgres

sql
auto-increment
sequences
best-practices

Compare dates in MySQL

sql
date-comparison
datetime
interval

Select rows which are not present in other table

sql
left-join
query-optimization
not-in

How do I delete from multiple tables using INNER JOIN in SQL server

sql
delete-operations
data-integrity
cascading-deletes

Current_timestamp in milliseconds

sql
timestamp
milliseconds
mysql

Division ( / ) not giving my answer in postgresql

sql
division
data-types
rounding

Avoid division by zero in PostgreSQL

sql
division
nullif
coalesce

How to hide result set decoration in Psql output

sql
psql
copy
best-practices

How to use count and group by at the same select statement

sql
group-by
count
subqueries

Modify Default value in SQL Server

sql
default-constraints
dynamic-sql
error-handling

Postgresql GROUP_CONCAT equivalent?

sql
string-agg
array-agg
mysql

Selecting COUNT(*) with DISTINCT

sql
distinct-counts
subqueries
null-values

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