Explain Codes LogoExplain Codes Logo

Sql

How to create Temp table with SELECT * INTO tempTable FROM CTE Query

sql
temp-tables
cte
sql-performance

Deleting duplicate rows from sqlite database

sql
database-normalization
performance-optimization
data-modeling

Convert Month Number to Month Name Function in SQL

sql
date-manipulation
sql-functions
dynamic-sql

Delete statement in SQL is very slow

sql
performance
optimization
best-practices

Postgresql - change the size of a varchar column to lower length

sql
database-alterations
postgresql-tips
data-integrity

Insert Data Into Temp Table with Query

sql
sql-server
temp-tables
conditional-statements

Sql ON DELETE CASCADE, Which Way Does the Deletion Occur?

sql
referential-integrity
database-schema
foreign-keys

Database in use error with Entity Framework 4 Code First

sql
database-initializer
entity-framework
connection-pooling

Ora-00972 identifier is too long alias column name

sql
database-management
oracle-12.2
hibernate-configuration

Mysql SELECT AS combine two columns into one

sql
concatenation
null-values
data-types

Mysql Inner Join with WHERE clause

sql
join
where-clause
sql-pitfalls

Oracle DB: How can I write query ignoring case?

sql
case-insensitive-search
sql-functions
database-performance

Mysql Like multiple values

sql
join
performance
best-practices

Custom Order in Oracle SQL

sql
join
performance
best-practices

How to calculate age (in years) based on Date of Birth and getDate()

sql
datetime-format
date-conversion
sql-functions

Time part of a DateTime Field in SQL

sql
date-time
sql-functions
time-extraction

Mysql GROUP BY two columns

sql
subqueries
group-by
having-clause

Sql subquery with COUNT help

sql
subquery
count
performance

How to reset Postgres' primary key sequence when it falls out of sync?

sql
best-practices
sequence-reset
postgres

Add a column with a default value to an existing table in SQL Server

sql
default-values
sql-server
table-operations
explain.codes / Sql