Explain Codes LogoExplain Codes Logo

Sql

What is the difference between JOIN and UNION?

sql
join
union
data-consolidation

How to delete from a table where ID is in a list of IDs?

sql
delete
transactions
best-practices

Finding duplicate rows in SQL Server

sql
duplicates
inner-join
deletion

Where value in column containing comma delimited values

sql
comma-separated
data-normalization
wildcard-search

Copy Data from a table in one Database to another separate database

sql
data-migration
performance
bulk-operations

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