Explain Codes LogoExplain Codes Logo

Sql

Sqlite - SELECT TOP syntax error

sql
limit-clause
database-pagination
sql-queries

Sql Server 2008: How to query all databases sizes?

sql
database-management
sql-query
storage-management

Select * from subquery

sql
subquery-aliasing
sql-queries
database-platforms

What is this operator <=> in MySQL?

sql
null-safe-comparisons
three-valued-logic
mysql-optimizer

How do you find results that occurred in the past week?

sql
performance
best-practices
database-indexing

Updating entry WITHOUT updating timestamp

sql
timestamp
update
mysql

Using CASE in WHERE Clause

sql
best-practices
logical-operators
sql-optimization

Sql update trigger only when column is modified

sql
trigger-engineering
best-practices
performance-tweaks

Distinct ON in an aggregate function in postgres

sql
prompt-engineering
join
lateral-subqueries

Sql ORDER BY date problem

sql
date-format
sql-performance
best-practices

How to select multiple rows filled with constants?

sql
sql-syntax
sql-queries
database-engine

How to get the identity of an inserted row?

sql
prompt-engineering
best-practices
transaction

How create json format with group-concat mysql?

sql
json-engineering
mysql
data-structures

Datetime2 vs DateTime in SQL Server

sql
datetime
sql-server
best-practices

Dynamic SELECT TOP @var in SQL Server

sql
dynamic-select
sql-server
top-clause

Converting int to real in SQLite

sql
data-type-conversion
sqlite-type-affinity
cast-function

Insert ... ON DUPLICATE KEY (do nothing)

sql
database
performance
best-practices

Aggregate function in an SQL update query?

sql
update-statements
aggregate-functions
sql-server

How do I split a delimited string so I can access individual items?

sql
string-parsing
sql-server
performance-tuning

Error 1046 No database selected, how to resolve?

sql
database-initialization
sql-optimization
error-handling
explain.codes / Sql