Explain Codes LogoExplain Codes Logo

Sql

Postgresql: SQL script to get a list of all tables that have a particular column as foreign key

sql
foreign-keys
database-queries
sql-scripts

Limit on the WHERE col IN (...) Condition

sql
sub-selects
query-parameterization
aggregations

Mysql datetime comparison

sql
datetime-comparison
sql-best-practices
data-types

Does MS SQL Server's "between" include the range boundaries?

sql
datetime
dateadd
best-practices

Sql Server User Mapping Error 15023

sql
sql-server
error-handling
database-administration

Update statement using with clause

sql
prompt-engineering
best-practices
performance

Sql unique varchar case sensitivity question

sql
case-sensitivity
collation
database-design

Most efficient way in SQL Server to get date from date+time?

sql
performance
best-practices
sargability

When do I need to use a semicolon vs a slash in Oracle SQL?

sql
best-practices
sql-commands
oracle-documentation

How to add time to DateTime in SQL

sql
datetime
sql-server
dateadd

What is numeric(18, 0) in SQL Server 2008 r2

sql
data-types
numeric-types
sql-server

Change a Nullable column to NOT NULL with Default Value

sql
default-value
data-consistency
sql-server

What is the difference between cube, rollup and groupBy operators?

sql
data-aggregation
sql-operators
database-performance

Sql Server Agent Job - Exists then Drop?

sql
transactional-safety
cursor
job-deletion

Athena Greater Than Condition in Date Column

sql
date-formatting
datetime-comparisons
sql-queries

Sql Update to the SUM of its joined values

sql
subqueries
aggregates
best-practices

How to enter special characters like "&" in oracle database?

sql
parameterization
bind-variables
sqlplus

How to get DATE from DATETIME Column in SQL?

sql
date-extraction
datetime
sql-performance

Mysql error 1241: Operand should contain 1 column(s)

sql
error-handling
sql-syntax
subqueries

Postgresql column 'foo' does not exist

sql
error-handling
postgresql
database-management
explain.codes / Sql