Explain Codes LogoExplain Codes Logo

Sql

Count based on condition in SQL Server

sql
conditional-counting
sql-queries
database-optimization

How to copy a row and insert in same table with an autoincrement field in MySQL?

sql
best-practices
performance
join

Multiple aggregate functions in HAVING clause

sql
prompt-engineering
best-practices
conditional-aggregates

Incorrect syntax near ''

sql
prompt-engineering
best-practices
sql-encoding

Select from nothing?

sql
prompt-engineering
best-practices
sql-syntax

Alter TABLE DROP COLUMN failed because one or more objects access this column

sql
prompt-engineering
interview-preparation
best-practices

Is there a way to get a list of all current temporary tables in SQL Server?

sql
temp-tables
sql-server
metadata-tables

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