Explain Codes LogoExplain Codes Logo

Sql

Sql DELETE with INNER JOIN

sql
best-practices
join
foreign-key-constraints

T-sql and the WHERE LIKE %Parameter% clause

sql
prompt-engineering
best-practices
performance

Convert a string to int using SQL query

sql
data-types
conversion
best-practices

Count the occurrences of DISTINCT values

sql
distinct
count
group-by

How to create a new schema/new user in Oracle Database 11g?

sql
database-management
schema-creation
oracle-database

C# SQL Server - Passing a list to a stored procedure

sql
tvp
parameterized-queries
sql-injection

How can I get column names from a table in SQL Server?

sql
metadata
information-schema
sql-server

How to convert all tables from MyISAM into InnoDB?

sql
database-conversion
mysql
innodb

How do I use variables in Oracle SQL Developer?

sql
bind-variables
substitution-variables
plsql

Why is SELECT * considered harmful?

sql
best-practices
performance
database-design

What is the difference between single and double quotes in SQL?

sql
best-practices
sql-standards
database-objects

How to use multiple WITH statements in one PostgreSQL query?

sql
join
ctes
performance

Create PostgreSQL ROLE (user) if it doesn't exist

sql
database-management
postgresql
role-management

How to get the top 10 values in PostgreSQL?

sql
performance
best-practices
sql-optimization

Partition Function COUNT() OVER possible using DISTINCT

sql
prompt-engineering
join
subqueries

Is varchar(MAX) always preferable?

sql
varchar-max
performance
best-practices

Using an Alias in a WHERE clause

sql
subquery
performance
best-practices

How to move tables from public to other schema in Postgres

sql
database-migration
postgres
schema-management

Query to check index on a table

sql
database-optimization
indexing-strategy
performance-tuning

Postgresql delete with inner join

sql
delete-join
postgresql
sql-best-practices
explain.codes / Sql