Explain Codes LogoExplain Codes Logo

Sql

How to group by month from Date field using SQL

sql
date-formatting
sql-server
group-by

Sql get the last date time record

sql
best-practices
performance
functions

Dataset Panel (Report Data) in SSRS Designer is Gone

sql
reporting-services
data-set
sql-server

How to use SQL LIKE condition with multiple values in PostgreSQL?

sql
regex
pattern-matching
sql-queries

Convert SQL Server result set into string

sql
string-concatenation
sql-server
data-types

Cannot simply use PostgreSQL table name ("relation does not exist")

sql
database-connection
postgresql-queries
sql-syntax

Sql recursive query that gets all ancestors of an item

sql
recursive-ctes
sql-queries
database-performance

Group BY and COUNT using ActiveRecord

sql
prompt-engineering
best-practices
join

Use cases for NoSQL

sql
database-design
data-modeling
nosql-databases

No unique or exclusion constraint matching the ON CONFLICT

sql
unique-constraints
database-design
conflict-resolution

Re-order columns of table in Oracle

sql
database-performance
sql-optimization
oracle-database

Auto Increment after delete in MySQL

sql
referential-integrity
database-design
sql-operations

Multiple FULL OUTER JOIN on multiple tables

sql
join
best-practices
data-consistency

Sql Server 2008: The columns in table do not match an existing primary key or unique constraint

sql
foreign-key
primary-key
database-schema

Sql query: Delete all records from the table except latest N?

sql
subquery
delete-records
database-performance

# What's the Difference Between "LIKE" and "=" in SQL? #

sql
best-practices
performance
join

How to get the latest record in each group using GROUP BY?

sql
join
subquery
performance

Oracle: What does `(+)` do in a WHERE clause?

sql
join
best-practices
sql-99

Drop table in old version of SQLite where IF EXISTS is not supported

sql
database-management
error-handling
best-practices

Datetime equal or greater than today in MySQL

sql
datetime
mysql
date-comparisons
explain.codes / Sql