Explain Codes LogoExplain Codes Logo

Sql

Insert with SELECT

sql
data-transformation
sql-functions
database-management

Script entire database SQL-Server

sql
scripting
database-management
sql-server

Don't update column if update value is null

sql
best-practices
performance
null-management

Why no windowed functions in where clauses?

sql
window-functions
sql-best-practices
query-optimization

Postgresql: INSERT INTO ... (SELECT * ...)

sql
performance
best-practices
sql-injection

Select n random rows from SQL Server table

sql
performance
randomness
sampling

How to Check for is Not Null and is Not Empty String in SQL Server?

sql
best-practices
performance
data-variants

Mysql Select rows on first occurrence of each unique value

sql
window-functions
mysql-8
performance

Sum of grouped COUNT in SQL Query

sql
sql-queries
group-by
window-functions

Only show hours in MYSQL DATEDIFF

sql
timestamp
unix_timestamp
timediff

Duplicate key on write or update?

sql
data-integrity
database-design
constraint-naming

How to change the default collation of a table?

sql
database-management
collation-alteration
mysql

Check if two "select"s are equivalent

sql
join
database
sql-standards

Get Table and Index storage size in SQL Server

sql
performance-tuning
storage-management
database-optimization

How to convert integer to decimal in SQL Server query?

sql
data-type-precedence
precision-control
error-handling

Mysql count group by having

sql
subqueries
sql-aggregation
group-by

Should I set max pool size in database connection string? What happens if I don't?

sql
database-connection
performance-optimization
best-practices

What's a PostgreSQL "Cluster" and how do I create one?

sql
database-management
postgresql-configuration
cluster-management

How to add a column and make it a foreign key in a single MySQL statement?

sql
foreign-key
mysql-manipulation
database-design

Mysql - How to grant read only permissions to a user?

sql
grant-permissions
mysql-privileges
database-security
explain.codes / Sql