Explain Codes LogoExplain Codes Logo

Sql

Mysql "Group By" and "Order By"

sql
join
subqueries
indexing

How to change a PG column to NULLABLE TRUE?

sql
database-design
performance-implications
postgresql

Use multiple conflict_target in ON CONFLICT clause

sql
prompt-engineering
best-practices
conflict-resolution

How to Store a List in a DB Column

sql
database-normalization
data-relationships
database-performance

How to fetch the row count for all tables in a SQL SERVER database

sql
database-performance
sql-scripts
database-maintenance

If statement in select (ORACLE)

sql
case-statement
oracle-nulls
sql-best-practices

Sql UPDATE SET one column to be equal to a value in a related table referenced by a different column?

sql
join
subqueries
transactions

Insert vs INSERT INTO

sql
best-practices
sql-standards
portability

Postgresql: How to create a table only if it does not already exist?

sql
database-interaction
error-prevention
schema-verification

How do I delete multiple rows with different IDs?

sql
delete-queries
performance-optimization
database-management

How can I update the top 100 records in SQL server

sql
update-records
sql-server
performance-optimization

Condition within JOIN or WHERE

sql
join
best-practices
performance

Php: maximum execution time when importing large .SQL data files

sql
importing-large-data
performance-optimization
command-line-tools

Add Foreign Key relationship between two Databases

sql
data-integrity
database-design
triggers

Mysql auto-store datetime for each row

sql
timestamp-management
database-design
mysql-optimization

Sql connection-string for localhost server

sql
connection-string
sql-server
database-connection

How to execute raw queries with Laravel 5.1?

sql
database-engineering
laravel
sql-queries

How can I determine the status of a job?

sql
job-status
sql-queries
database-management

Sql Server equivalent to MySQL enum data type?

sql
data-integrity
check-constraints
enum-data-type

How to delete duplicate rows in SQL Server?

sql
data-deletion
sql-server
best-practices
explain.codes / Sql