Explain Codes LogoExplain Codes Logo

Sql

Get generated id after insert

sql
database-resources
performance-optimization
best-practices

Difference between one-to-many and many-to-one relationship

sql
database-design
data-integrity
normalization

Sql SELECT from multiple tables

sql
join
union
query-optimization

Sql "between" not inclusive

sql
date-comparison
datetime
inclusive-query

How to identify all stored procedures referring to a particular table

sql
sql-server
stored-procedures
database-management

Rank function in MySQL

sql
rank-function
mysql-optimization
sql-queries

When is a good situation to use a full outer join?

sql
join
performance
best-practices

How do I find the data directory for a SQL Server instance?

sql
sql-server
database-management
data-directory

Split string and take last element

sql
functions
best-practices
conditional-checks

Check if value exists in Postgres array

sql
array-manipulation
sql-queries
database-performance

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS

sql
subquery
sql-queries
database-performance

Sql Populate table with random data

sql
random-data
sql-functions
postgresql

Mysql query finding values in a comma separated string

sql
prompt-engineering
best-practices
data-organization

Permanently Set Postgresql Schema Path

sql
database
postgresql
schema

How to select only the first rows for each unique value of a column?

sql
prompt-engineering
join
best-practices

How can I select rows with the most recent timestamp for each key value?

sql
window-functions
optimization
performance-tuning

How to use NULL or empty string in SQL

sql
best-practices
data-types
performance

How can I get column names from a table in Oracle?

sql
database-management
oracle
sql-queries

Create TABLE IF NOT EXISTS equivalent in SQL Server

sql
best-practices
database-design
sql-server

Rounding off to two decimal places in SQL

sql
precision
rounding
data-types