Explain Codes LogoExplain Codes Logo

Sql

Show the current username in MySQL?

sql
database-connection
mysql-queries
security-best-practices

Sql Return only duplicate rows

sql
subquery
join
window-functions

Unpivot with column name

sql
sql-fiddle
pivot-tables
performance-optimization

When or why would you use a right outer join instead of left?

sql
join
data-integrity
sql-performance

How to find duplicate records in PostgreSQL

sql
prompt-engineering
best-practices
join

Sql Server, division returns zero

sql
decimal-data-types
division-by-zero
sql-server-performance

Sql Server - Return value after INSERT

sql
best-practices
sql-server
output-clause

T-sql split string

sql
string-split
sql-server
delimiter

Tsql - How to use GO inside of a BEGIN .. END block?

sql
dynamic-sql
try-catch
sql-execution

How to SELECT WHERE NOT EXIST using LINQ?

sql
linq-transformation
sql-linq
entity-framework

How to select all records from one table that do not exist in another table?

sql
join
performance
best-practices

How do I create a foreign key in SQL Server?

sql
foreign-key
database-design
referential-integrity

Altering column size in SQL Server

sql
best-practices
data-integrity
sql-syntax

How to do the Recursive SELECT query in MySQL?

sql
recursive-procedures
best-practices
stored-procedures

How to update selected rows with values from a CSV file in Postgres?

sql
best-practices
data-integrity
performance

Get list of all tables in Oracle?

sql
database-views
oracle-queries
metadata

Set database from SINGLE USER mode to MULTI USER

sql
database-management
sql-server
multi-user-mode

How to select a column name with a space in MySQL

sql
best-practices
sql-syntax
database-management

Detect if value is number in MySQL

sql
regexp
mysql
numeric-patterns

How to retrieve JSON data from MySQL?

sql
json-handling
mysql-performance
database-normalization
explain.codes / Sql