Explain Codes LogoExplain Codes Logo

Sql

How to strip HTML tags from a string in SQL Server?

sql
html-stripping
user-defined-functions
xml-method

Find all tables containing column with specified name - MS SQL Server

sql
information-schema
metadata
query-optimization

Select count(*) from multiple tables

sql
count
joins
performance

Mysql Foreign key constraint is incorrectly formed error

sql
foreign-key
data-integrity
indexing

Mysql - Get row number on select

sql
row-number
subqueries
pagination

How to get input file name as column in AWS Athena external tables

sql
aws
data-lake
query-optimization

Sql Server: IF EXISTS ; ELSE

sql
performance
set-based
case

Simple Random Samples from a MySQL Sql database

sql
random-sampling
performance
query-optimization

Cross JOIN vs INNER JOIN in SQL

sql
inner-join
cross-join
performance

Reset auto increment counter in postgres

sql
auto-increment
sequences
best-practices

Compare dates in MySQL

sql
date-comparison
datetime
interval

Select rows which are not present in other table

sql
left-join
query-optimization
not-in

How do I delete from multiple tables using INNER JOIN in SQL server

sql
delete-operations
data-integrity
cascading-deletes

Current_timestamp in milliseconds

sql
timestamp
milliseconds
mysql

Division ( / ) not giving my answer in postgresql

sql
division
data-types
rounding

Avoid division by zero in PostgreSQL

sql
division
nullif
coalesce

How to hide result set decoration in Psql output

sql
psql
copy
best-practices

How to use count and group by at the same select statement

sql
group-by
count
subqueries

Modify Default value in SQL Server

sql
default-constraints
dynamic-sql
error-handling

Postgresql GROUP_CONCAT equivalent?

sql
string-agg
array-agg
mysql
explain.codes / Sql