Explain Codes LogoExplain Codes Logo

Sql

Efficient latest record query with PostgreSQL

sql
indexing
window-functions
performance-optimization

Why doesn't SQL Server support unsigned datatype?

sql
data-types
performance
best-practices

How to visualize database tables in PostgreSQL using pgAdmin?

sql
database-visualization
pgadmin
postgresql

Mysql: Invalid use of group function

sql
database-design
sql-queries
group-by

How to alter a column and change the default value?

sql
database-structure
sql-commands
data-types

Postgresql unnest() with element number

sql
prompt-engineering
advanced-sql
postgresql

Pass table as parameter into sql server UDF

sql
udfs
sql-server
performance-optimization

Delete all but top n from database table in SQL

sql
performance
best-practices
data-integrity

Delete from two tables in one query

sql
transaction
foreign-key
join

Sql: set existing column as Primary Key in MySQL

sql
database-design
data-types
error-handling

Mysql - how to front pad zip code with "0"?

sql
data-consistency
database-design
sql-best-practices

Sql Server: Extract Table Meta-Data (description, fields and their data types)

sql
metadata
database-management
sql-server

How to compare datetime with only date in SQL Server

sql
best-practices
performance
join

Quick selection of a random row from a large table in MySQL

sql
join
indexing
performance

Join between tables in two different databases?

sql
cross-database-join
database-optimization
sql-performance

Can I Comma Delimit Multiple Rows Into One Column?

sql
string-aggregation
query-optimization
sql-techniques

Sql Left Join first match only

sql
join
subqueries
performance

Full OUTER JOIN vs. FULL JOIN

sql
join
data-quality
query-optimization

Is there common street addresses database design for all addresses of the world?

sql
database-design
geocoding
data-normalization

Postgresql Index Usage Analysis

sql
database-performance
index-optimization
postgresql
explain.codes / Sql