Explain Codes LogoExplain Codes Logo

Sql

Finding and Deleting Duplicate Rows in PostgreSQL

sql
performance-tuning
database-optimization
postgresql

Postgresql - select something where date = "01/01/11"

sql
type-casting
date-format
postgresql

Select multiple columns into multiple variables

sql
select-into
data-type
error-handling

Cannot execute script: Insufficient memory to continue the execution of the program

sql
memory-optimization
sql-server
script-execution

Get AVG ignoring Null or Zero values

sql
prompt-engineering
best-practices
join

Use email address as a primary key?

sql
database-design
primary-key
database-performance

Subtract month and day mysql

sql
date-subtraction
mysql-functions
performance-optimization

How can I select from list of values in Oracle

sql
regexp-substr
sql-type
database-schema

Sql Server converting varbinary to string

sql
data-conversion
sql-server
binary-data

Mysql datatype to store month and year only

sql
data-types
date-format
database-performance

Why would someone use WHERE 1=1 AND in a SQL clause?

sql
dynamic-queries
sql-injection
best-practices

Subtract one day from datetime

sql
date-manipulation
datetime-functions
sql-dateadd

Return value from exec(@sql)

sql
prompt-engineering
best-practices
data-usage

How do I insert datetime value into a SQLite database?

sql
datetime
parameterized-queries
sqlite-functions

How do you write a conditional in a MySQL select statement?

sql
conditional-logic
mysql-queries
best-practices

Why should I capitalize my SQL keywords? Is there a good reason?

sql
best-practices
readability
sql-lexicon

What are the pros and cons to keeping SQL in Stored Procs versus Code

sql
best-practices
performance
debugging

How do I combine 2 select statements into one?

sql
subqueries
sql-queries
performance

What are valid table names in SQLite?

sql
database-design
sql-best-practices
sqlite

Check if MySQL table exists without using "select from" syntax?

sql
database-operations
performance-optimization
mysql-queries