Explain Codes LogoExplain Codes Logo

Sql

Sql update trigger only when column is modified

sql
trigger-engineering
best-practices
performance-tweaks

Distinct ON in an aggregate function in postgres

sql
prompt-engineering
join
lateral-subqueries

Sql ORDER BY date problem

sql
date-format
sql-performance
best-practices

How to select multiple rows filled with constants?

sql
sql-syntax
sql-queries
database-engine

How to get the identity of an inserted row?

sql
prompt-engineering
best-practices
transaction

How create json format with group-concat mysql?

sql
json-engineering
mysql
data-structures

Datetime2 vs DateTime in SQL Server

sql
datetime
sql-server
best-practices

Dynamic SELECT TOP @var in SQL Server

sql
dynamic-select
sql-server
top-clause

Converting int to real in SQLite

sql
data-type-conversion
sqlite-type-affinity
cast-function

Insert ... ON DUPLICATE KEY (do nothing)

sql
database
performance
best-practices

Aggregate function in an SQL update query?

sql
update-statements
aggregate-functions
sql-server

How do I split a delimited string so I can access individual items?

sql
string-parsing
sql-server
performance-tuning

Error 1046 No database selected, how to resolve?

sql
database-initialization
sql-optimization
error-handling

How to Sort the Results of a LEFT JOIN in an SQL Query

sql
join
group-by
aggregate-functions

Mysql: How to copy rows, but change a few fields?

sql
data-alteration
sql-queries
database-management

How to change the CHARACTER SET (and COLLATION) throughout a database?

sql
database-migration
character-set
collation

How to get the insert ID in JDBC?

sql
jdbc
best-practices
database-operations

How to query a CLOB column in Oracle

sql
prompt-engineering
best-practices
lob

Delete rows with foreign key in PostgreSQL

sql
foreign-key
database-integrity
performance-optimization

Create new user in MySQL and give it full access to one database

sql
database-security
mysql-privileges
sql-commands
explain.codes / Sql