Explain Codes LogoExplain Codes Logo

Sql

Inner Joining three tables

sql
join
best-practices
performance

Mysql strip time component from datetime

sql
date-formatting
datetime
mysql

How to join only one row in joined table with Postgres?

sql
prompt-engineering
performance
best-practices

Passing List<> to SQL Stored Procedure

sql
table-valued-parameters
performance-optimization
sql-server

Update a column value, replacing part of a string

sql
bulk-updates
string-functions
database-administration

Creating temporary tables in SQL

sql
prompt-engineering
best-practices
transaction

Sql how to make null values come last when sorting ascending

sql
null-handling
sql-queries
database-performance

Update multiple rows in same query using PostgreSQL

sql
update
postgresql
performance

Sql distinct for 2 fields in a database

sql
distinct
group-by
indexing

How to use SQL Select statement with IF EXISTS subquery?

sql
prompt-engineering
best-practices
performance

Insert if Not Exists Oracle

sql
conditional-inserts
oracle-sql
exception-handling

Store Arabic in SQL Database

sql
database-settings
unicode-support
collation

The quandary of the GROUP BY clause and aggregate functions in SQL

sql
aggregate-functions
group-by-clause
sql-databases

Get all characters before space in MySQL

sql
string-functions
data-manipulation
query-customization

Display names of all constraints for a table in Oracle SQL

sql
database-administration
sql-queries
constraint-management

Is there a Max function in SQL Server that takes two values like Math.Max in .NET?

sql
max-function
sql-server
math-max

Write a number with two decimal places SQL Server

sql
decimal
format-function
sql-performance

Join two SELECT statement results

sql
join
sql-queries
database-operations

Select from table by knowing only date without time (ORACLE)

sql
performance
indexes
best-practices

How do I escape a single quote in SQL Server?

sql
sql-escape
sql-queries
sql-best-practices
explain.codes / Sql