Explain Codes LogoExplain Codes Logo

Sql

How to delete duplicate rows in SQL Server?

sql
data-deletion
sql-server
best-practices

Concatenate multiple rows in an array with SQL on PostgreSQL

sql
array_agg
postgresql
data-aggregation

What does "select count(1) from table_name" on any database tables mean?

sql
count-function
sql-performance
database-optimization

Mysql LIKE IN()?

sql
regexp
like
performance

Remove duplicate rows in MySQL

sql
prompt-engineering
best-practices
join

Using union and count(*) together in an SQL query

sql
join
performance
best-practices

Sql query to select dates between two dates

sql
date-range
sql-queries
datetime

Use variable with TOP in select statement in SQL Server without making it dynamic

sql
prompt-engineering
best-practices
join

Is it possible to use the SELECT INTO clause with UNION [ALL]?

sql
prompt-engineering
best-practices
performance

How can you tell if a value is not numeric in Oracle?

sql
data-validation
oracle-12c
numeric-validation

Which sql server data type best represents a double in C#?

sql
precision
rounding
data-type

Execute STORED PROCEDURE FROM A FUNCTION

sql
sqlclr
stored-procedures
dynamic-sql

How to log SQL statements in Grails

sql
logback
sql-logging
hibernate

Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?

sql
join
best-practices
performance

Sql formatting standards

sql
best-practices
sql-formating
database-optimization

Best way to check for "empty or null value"

sql
prompt-engineering
best-practices
performance

Is there a LastIndexOf in SQL Server?

sql
udfs
performance
ctes

Drop view if exists

sql
best-practices
sql-server
view-management

Fastest Way of Inserting in Entity Framework

sql
bulk-insert
entity-framework
performance-optimization

Referring to a Column Alias in a WHERE Clause

sql
prompt-engineering
best-practices
performance
explain.codes / Sql