Explain Codes LogoExplain Codes Logo

Sql

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

Convert INT to VARCHAR SQL

sql
sql-conversion
data-types
database-operations

Multiple level ordering

sql
prompt-engineering
best-practices
join

Insert into ... values (SELECT ... FROM ...)

sql
prompt-engineering
best-practices
performance

What's the difference between RANK() and DENSE_RANK() functions in oracle?

sql
ranking
null-handling
dense-rank

How do SQL EXISTS statements work?

sql
subquery
performance
best-practices

How do you strip a character out of a column in SQL Server?

sql
data-integrity
sql-queries
database-management

How to make a view column NOT NULL

sql
null-proofing
default-values
conditional-logic

How to print GETDATE() in SQL Server with milliseconds in time?

sql
datetime
timestamp
performance-tracking

How to store a list in a column of a database table

sql
database-design
data-serialization
database-performance

Postgresql syntax check without running the query

sql
tools
best-practices
syntax-checking

How can I compare time in SQL Server?

sql
datetime
time-comparison
sql-functions

How can I get multiple counts with one SQL query?

sql
performance
best-practices
conditional-aggregation

How to get the last day of month in postgres?

sql
interval-expression
date-trunc
custom-function
explain.codes / Sql