Explain Codes LogoExplain Codes Logo

Sql

Efficient way to implement paging

sql
paging
performance
stored-procedures

Sqlite - replace part of a string

sql
string-manipulation
backup
custom-functions

How do you use script variables in psql?

sql
variables
sql-injection
postgresql

Using DISTINCT and COUNT together in a MySQL Query

sql
distinct
count
subqueries

In SQL, what's the difference between count(column) and count(*)?

sql
count
nulls
joins

How to use andWhere and orWhere in Doctrine?

sql
query-optimization
conditions
doctrine

Insert text with single quotes in PostgreSQL

sql
sql-injection
parameterized-queries
postgresql

Import CSV file into SQL Server

sql
csv-import
data-cleanup
performance

Add days Oracle SQL

sql
date-manipulation
intervals
precision

How to insert a line break in a SQL Server VARCHAR/NVARCHAR string

sql
line-breaks
stored-procedures
string-aggregation

Database Naming Conventions by Microsoft?

sql
naming-conventions
readability
best-practices

Sql Server SELECT INTO @variable?

sql
table-variables
temporary-tables
data-manipulation

Sql- Ignore case while searching for a string

sql
case-insensitivity
collation
wildcards

Mysql: Update Field Only if Condition Is Met

sql
conditional-updates
case-statement
data-integrity

# "where 1=1" statement

sql
dynamic-sql
query-optimization
sql-injection

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