Explain Codes LogoExplain Codes Logo

Sql

How to select records without duplicate on just one field in SQL?

sql
distinct
aggregate-functions
subqueries

How do I get the current year using SQL on Oracle?

sql
date-manipulation
oracle-sql
database-queries

Escaping keyword-like column names in Postgres

sql
database-design
sql-best-practices
postgres

How do I obtain a Query Execution Plan in SQL Server?

sql
query-execution-plan
sql-server
performance-optimization

Why can't I use "create schema" in a begin/end block in SQL Management Studio?

sql
sql-server
schema-creation
dynamic-sql

How to select several hardcoded SQL rows?

sql
best-practices
performance
join

Order by descending date - month, day, and year

sql
date-sorting
database-performance
best-practices

Using MySql, can I sort a column but have 0 come last?

sql
sql-sorting
mysql-tricks
data-manipulation

Convert varchar to uniqueidentifier in SQL Server

sql
guid
sql-server
data-integrity

Sql Server : How to test if a string has only digit characters

sql
prompt-engineering
best-practices
dataframe

Explaining why 'Just add another column to the DB' is a bad idea, to non programmers

sql
database-normalization
data-bloating
database-design

Best way to handle nested case statement logic in SQL Server

sql
case-statements
sql-best-practices
error-handling

Store MySQL query output into a shell variable

sql
mysql
database
query

Unknown column in 'field list' error on MySQL Update query

sql
best-practices
join
sql-queries

Rename a constraint in SQL Server?

sql
best-practices
database-design
sql-server

Counting the number of occurrences of a substring within a string in PostgreSQL

sql
prompt-engineering
best-practices
regexp

Create SQL INSERT Script with values gathered from table

sql
sql-scripts
data-migration
sql-injections

Create SQL script that creates a database and tables

sql
scripting
database-creation
sql-server

What are the benefits of using database cursor?

sql
cursor-optimization
database-performance
sql-queries

How to remove not null constraint in SQL Server using query

sql
best-practices
data-integrity
sql-server
explain.codes / Sql