Explain Codes LogoExplain Codes Logo

Sql

Use '=' or LIKE to compare strings in SQL?

sql
database-optimization
sql-performance
string-comparison

Using group by on multiple columns

sql
group-by
aggregation
sql-queries

Can parameterized statement stop all SQL injection?

sql
sql-injection
parameterized-statements
database-security

Return Boolean Value on SQL Select Statement

sql
prompt-engineering
best-practices
performance

How Do I Extract Data from a DataTable?

sql
datareader
field-t
data-tables

Distinct pair of values SQL

sql
distinct
group-by
sql-performance

What is the difference between "INNER JOIN" and "OUTER JOIN"?

sql
join
sql-queries
database-operations

Querying WHERE condition to character length?

sql
prompt-engineering
best-practices
data-type

Update statement with inner join on Oracle

sql
join
performance
best-practices

How to sort the result from string_agg()

sql
string_agg
postgresql
sql-queries

Copy data into another table

sql
bulk-operations
data-transfer
sql-best-practices

Postgres - How to check for an empty array

sql
array-literals
postgresql-functions
sql-queries

Max(length(field)) in mysql

sql
prompt-engineering
best-practices
data-pruning

Adding a leading zero to some values in column in MySQL

sql
prompt-engineering
best-practices
data-integrity

How to Alter Constraint

sql
database-management
constraint-modification
foreign-key-constraints

Lightweight SQL editor for Eclipse

sql
sql-editors
eclipse-plugins
database-development

How to Find the Longest String in a Table Column Data

sql
performance
best-practices
join

Sql error errno: 121

sql
constraint-naming
error-handling
mysql-optimization

Index for finding an element in a JSON array

sql
indexing
postgresql
jsonb

Increment field of mysql database using codeigniter's active record syntax

sql
database-manipulation
active-record-syntax
mysql-queries
explain.codes / Sql