Explain Codes LogoExplain Codes Logo

Sql

Run raw SQL in migration

sql
raw-sql
migrations
database

Group by date only on a Datetime column

sql
group-by
date-filtering
performance

Mysql :: insert into table, data from another table?

sql
insert
data-migration
performance

Sqlplus statement from the command line

sql
sqlplus
security
complex-queries

Sort by column ASC, but NULL values first?

sql
nulls-first
query-optimization
case-statement

Difference between Select Unique and Select Distinct

sql
select-distinct
data-integrity
unique-constraints

Generate a resultset of incrementing dates in T-SQL

sql
date-generation
performance
common-table-expressions

Get mySQL MONTH() to use leading zeros?

sql
date-format
leading-zeros
time-zones

Mysql CREATE FUNCTION Syntax

sql
functions
best-practices
error-handling

How to select rows that have the current day's timestamp?

sql
date-comparison
indexing
execution-plans

How do I ignore ampersand characters in a SQL script running from SQL Plus?

sql
ampersand
set-define
best-practices

Execute SQL script from command line

sql
sqlcmd
automation
backup

Rails 3 Execute Custom SQL Query Without a Model

sql
raw-sql
active-record
sql-injection

Postgresql Crosstab Query

sql
crosstab
data-integrity
json-functions

How to query a json column for empty objects?

sql
json
indexing
performance

Select data from date range between two dates

sql
date-range
between
performance

Truncate (not round) decimal places in SQL Server

sql
truncation
round
best-practices

How to return only the Date from a SQL Server DateTime datatype

sql
date-formatting
performance
null-handling

What is the most efficient/elegant way to parse a flat table into a tree?

sql
recursive-queries
closure-tables
path-enumeration

Postgresql - query from bash script as database user 'postgres'

sql
bash-scripting
dynamic-sql
error-handling
explain.codes / Sql