Explain Codes LogoExplain Codes Logo

Sql

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

What does (1,1) mean in SQL?

sql
identity-columns
auto-incrementing
database-performance

Removing leading zeroes from a field in a SQL statement

sql
prompt-engineering
best-practices
join

How to write SQL in a migration in Rails

sql
database-migration
rails-migration
sql-queries

Is there a good reason to use upper case for SQL keywords?

sql
best-practices
sql-style
readability

How do I grant read access for a user to a database in SQL Server?

sql
database-access
sql-server
permissions-management

Mysql query String contains

sql
prompt-engineering
best-practices
fulltext-indices

Listagg in Oracle to return distinct values

sql
listagg
distinct-values
oracle-sql

Sql: find missing IDs in a table

sql
join
performance
optimizations

Grouped LIMIT in PostgreSQL: Show the first N rows for each group?

sql
prompt-engineering
performance
best-practices
explain.codes / Sql