Explain Codes LogoExplain Codes Logo

Sql

How do I add multiple "NOT LIKE '%?%' in the WHERE clause of sqlite3?

sql
prompt-engineering
best-practices
performance

Select the max value of each group

sql
prompt-engineering
best-practices
join

How to select unique records by SQL

sql
distinct
group-by
sql-syntax

What's the purpose of SQL keyword "AS"?

sql
best-practices
join
sub-queries

Create or replace trigger postgres

sql
transactional-ddl
trigger-management
database-structures

Sql GROUP BY CASE statement with aggregate function

sql
subqueries
ctes
aggregate-functions

Getting a date list in a range in PostgreSQL

sql
prompt-engineering
best-practices
performance

Equivalent of LIMIT and OFFSET for SQL Server?

sql
pagination
offset
fetch-next

Generating a random & unique 8 character string using MySQL

sql
prompt-engineering
best-practices
performance

Why does this SQLite query select all dates, even those outside of the criteria?

sql
prompt-engineering
best-practices
date-functions

Sql Server FOR EACH Loop

sql
set-based-operations
recursive-cte
execution-plans

Full OUTER JOIN with SQLite

sql
full-outer-join
sqlite
sql-queries

How to Handle a Single Quote in Oracle SQL

sql
sql-injection
dynamic-sql
concatenation

Bulk/batch update/upsert in PostgreSQL

sql
bulk-inserts
performance-optimization
postgresql

What are the differences between T-SQL, SQL Server, and SQL

sql
sql-server
t-sql
database-management

How can I get a plain text postgres database dump on Heroku?

sql
database-dump
heroku
postgres

Extracting Hours from a DateTime (SQL Server 2005)

sql
datepart-function
datetime-components
performance-tips

Disable all table constraints in Oracle

sql
constraint-handling
plsql
database-performance

Difference between primary key and unique key

sql
database-design
data-integrity
key-concepts

How can I backup a remote SQL Server database to a local drive?

sql
backup
sql-server
database-management
explain.codes / Sql