Explain Codes LogoExplain Codes Logo

Sql

What does (1,1) mean in SQL?

sql
identity-columns
auto-incrementing
database-performance

Removing leading zeroes from a field in a SQL statement

sql
prompt-engineering
best-practices
join

How to write SQL in a migration in Rails

sql
database-migration
rails-migration
sql-queries

Is there a good reason to use upper case for SQL keywords?

sql
best-practices
sql-style
readability

How do I grant read access for a user to a database in SQL Server?

sql
database-access
sql-server
permissions-management

Mysql query String contains

sql
prompt-engineering
best-practices
fulltext-indices

Listagg in Oracle to return distinct values

sql
listagg
distinct-values
oracle-sql

Sql: find missing IDs in a table

sql
join
performance
optimizations

Grouped LIMIT in PostgreSQL: Show the first N rows for each group?

sql
prompt-engineering
performance
best-practices

Maximum size for a SQL Server Query? IN clause? Is there a Better Approach

sql
best-practices
performance
optimizing

How to list table foreign keys

sql
foreign-keys
postgresql
mysql

Mysql_config not found when installing mysqldb python interface

sql
mysql-config
mysql-python
pip-installation

Key value pairs in relational databases

sql
database-design
data-integrity
query-optimization

How to remove duplicates, which are generated with array_agg postgres function

sql
array_agg
distinct
postgresql

Get RETURN value from stored procedure in SQL

sql
stored-procedures
return-values
sql-scripts

Cast from VARCHAR to INT - MySQL

sql
data-type-conversion
mysql-performance
sql-optimization

Sql "IF", "BEGIN", "END", "END IF"?

sql
conditional-statements
sql-try-catch
dynamic-sql

How to declare variable and use it in the same Oracle SQL script?

sql
bind-variables
substitution-variables
oracle-sql

How to concatenate strings of a string field in a PostgreSQL 'group by' query?

sql
string-aggregation
postgresql
database-performance

Mysql remove duplicates from big database quick

sql
deduplication
performance-optimization
mysql-queries
explain.codes / Sql