Explain Codes LogoExplain Codes Logo

Sql

Sql Case Expression Syntax?

sql
conditional-aggregation
case-expressions
sql-queries

The total number of locks exceeds the lock table size

sql
transaction-management
mysql-configuration
performance-optimization

Row Offset in SQL Server

sql
performance
best-practices
pagination

How do I concatenate text in a query in SQL Server?

sql
prompt-engineering
join
best-practices

Postgresql - sql - count of `true` values

sql
prompt-engineering
best-practices
join

How to move columns in a MySQL table?

sql
database-management
sql-commands
data-organization

Split function equivalent in T-SQL?

sql
string-splitting
xml-guide
sql-server

Difference between Oracle's plus (+) notation and ANSI JOIN notation?

sql
join
best-practices
performance

How to change Column size of varchar type in mySQL?

sql
database-management
data-types
performance-optimization

Difference between a statement and a query in SQL

sql
sql-syntax
sql-performance
sql-best-practices

Select column, if blank select from another

sql
nullif
coalesce
custom-functions

How to get N rows starting from row M from a sorted table in T-SQL

sql
pagination
database-engine
performance-optimization

What is difference between foreign key and reference key?

sql
foreign-key
best-practices
referential-integrity

Dbeaver, How to declare variables & use them?

sql
prompt-engineering
best-practices
sql-queries

Export result set on DBeaver to CSV

sql
export
csv
databases

Postgresql DISTINCT ON with different ORDER BY

sql
distinct-on
postgresql
sql-performance

How to create a composite primary key in SQL Server 2008

sql
primary-key
database-design
sql-server

Sql Server: Invalid Column Name

sql
sql-server
database-schema
error-handling

What's the fastest way to do a bulk insert into Postgres?

sql
bulk-insert
postgresql
performance-tuning

Why can't I use an alias for an aggregate in a having clause?

sql
subqueries
common-table-expressions
sql-server