Explain Codes LogoExplain Codes Logo

Sql

Why is SELECT * considered harmful?

sql
best-practices
performance
database-design

What is the difference between single and double quotes in SQL?

sql
best-practices
sql-standards
database-objects

How to use multiple WITH statements in one PostgreSQL query?

sql
join
ctes
performance

Create PostgreSQL ROLE (user) if it doesn't exist

sql
database-management
postgresql
role-management

How to get the top 10 values in PostgreSQL?

sql
performance
best-practices
sql-optimization

Partition Function COUNT() OVER possible using DISTINCT

sql
prompt-engineering
join
subqueries

Is varchar(MAX) always preferable?

sql
varchar-max
performance
best-practices

Using an Alias in a WHERE clause

sql
subquery
performance
best-practices

How to move tables from public to other schema in Postgres

sql
database-migration
postgres
schema-management

Query to check index on a table

sql
database-optimization
indexing-strategy
performance-tuning

Postgresql delete with inner join

sql
delete-join
postgresql
sql-best-practices

Sql INSERT INTO from multiple tables

sql
join
performance
best-practices

How can I list the tables in a SQLite database file that was opened with ATTACH?

sql
sqlite
database-management
sql-commands

Is MySQL "between" clause not inclusive?

sql
datetime
timestamp
date

Online databases for trying out Oracle SQL queries?

sql
online-databases
sql-practice
database-management

Postgresql list and order tables by size

sql
database-management
postgresql
sql-queries

Sql User Defined Function Within Select

sql
udf
sql-performance
data-transformations

How do I find the creation date of a MySQL table?

sql
metadata
database-performance

Group by day from timestamp

sql
group-by
timestamp
date-formatting

Invalid default value for 'dateAdded'

sql
default-values
mysql-versions
error-handling
explain.codes / Sql