Explain Codes LogoExplain Codes Logo

Sql

Merge two rows in SQL

sql
join
aggregate-functions
subqueries

Do I need to create indexes on foreign keys on Oracle?

sql
database-indexing
foreign-keys
oracle-performance

Sql Server: Making all UPPER case to Proper Case/Title Case

sql
prompt-engineering
best-practices
performance

How can I create a unique constraint on my column (SQL Server 2008 R2)?

sql
unique-constraint
sql-server
database-design

Get records with max value for each group of grouped SQL results

sql
subquery
window-functions
sql-optimization

Is it better to create an index before filling a table with data, or after the data is in place?

sql
index-creation
database-performance
data-loading

How to insert a value that contains an apostrophe (single quote)?

sql
sql-injection
parameterized-queries
orm

How to skip certain database tables with mysqldump?

sql
mysqldump
database-backup
sql-commands

Primary key/foreign Key naming convention

sql
best-practices
database-design
naming-conventions

How do I convert a database row into a struct

sql
database-mapping
struct-conversion
sql-null-values

How to Concatenate Numbers and Strings to Format Numbers in T-SQL?

sql
null-value-management
data-type-casting
error-handling

Clustered vs Non-Clustered

sql
index-design
performance-tuning
database-administration

How to do INSERT into a table records extracted from another table

sql
insert-into-select
sql-queries
data-aggregation

Sql update fields of one table from fields of another one

sql
dynamic-sql
postgresql
database-queries

Mysql comparison with null value

sql
null-safe-operator
coalesce-function
null-handling

How to check if a field is null or empty in MySQL?

sql
prompt-engineering
best-practices
performance

Adding an identity to an existing column

sql
identity-insert
database-migration
sql-server

Group query results by month and year in PostgreSQL

sql
database
date-formatting
group-by

How to group by hour in PostgreSQL using "time" field?

sql
date_trunc
date_part
time-zone

Postgresql visual interface similar to phpMyAdmin?

sql
database-administration
postgresql-tools
interface-comparison
explain.codes / Sql