Explain Codes LogoExplain Codes Logo

Sql

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

How to call scalar function in SQL Server 2008

sql
best-practices
functions
error-management

Sql standard to escape column names?

sql
identifier-delimiters
sql-standard
database-compatibility

How can I delete using INNER JOIN with SQL Server?

sql
prompt-engineering
best-practices
performance

Create a Superuser in postgres

sql
database-management
postgresql
superuser-creation

How to get/generate the create statement for an existing hive table?

sql
hive
ddl
database-management

Error related to only_full_group_by when executing a query in MySql

sql
sql-standards
group-by
mysql-5.7

Select Top 1 field and assign to local variable

sql
prompt-engineering
best-practices
error-handling

Find records from one table which don't exist in another

sql
performance
best-practices
database

Error in SQL script: Only one statement is allowed per batch

sql
best-practices
tools
project-settings
explain.codes / Sql