Explain Codes LogoExplain Codes Logo

Sql

Or is not supported with CASE Statement in SQL Server

sql
best-practices
performance
data-type

Oracle - Why does the leading zero of a number disappear when converting it TO_CHAR

sql
format-models
performance-overhead
best-practices

Ora-01791: not a SELECTed expression

sql
join
best-practices
performance

Ora-00904: Invalid Identifier

sql
sql-syntax
error-handling
debugging

Mysql Select Query - Get only the first 10 characters of a value

sql
database-performance
string-manipulation
mysql-functions

Mysql Query GROUP BY day / month / year

sql
date-functions
performance-optimization
mysql-queries

Mysql JDBC Driver 5.1.33 - Time Zone Issue

sql
mysql-connector
timezone-issues
jdbc-driver

Mysql INNER JOIN select only one row from second table

sql
subquery
join
performance

Mysql: How to insert a record for each result in a SQL query?

sql
bulk-insertion
sql-queries
data-integrity

Mysql how to fill missing dates in range?

sql
left-join
date-series
mysql-8

Mysql function to find the number of working days between two dates

sql
prompt-engineering
best-practices
performance

Mysql - Conditional Foreign Key Constraints

sql
conditional-foreign-key
polymorphic-associations
supertable

Mysql can't make column auto_increment

sql
sql-mode
auto-increment
data-integrity

Mysql 1062 - Duplicate entry '0' for key 'PRIMARY'

sql
database-structure
data-integrity
sql-queries

List columns with indexes in PostgreSQL

sql
index-inspection
postgresql-utilities
database-search

Listagg function: "result of string concatenation is too long"

sql
listagg
string-concatenation
performance-tips

Is there any reason to worry about the column order in a table?

sql
best-practices
database-design
performance-optimization

In SQL, how can you "group by" in ranges?

sql
group-by
bucketing
sql-queries

Insert into a MySQL table or update if exists

sql
on-duplicate-key-update
insert-ignore
replace-into

Inserting multiple rows in a single SQL query?

sql
bulk-insert
performance-optimization
database-operations
explain.codes / Sql