Explain Codes LogoExplain Codes Logo

Sql

Sql query: Delete all records from the table except latest N?

sql
subquery
delete-records
database-performance

# What's the Difference Between "LIKE" and "=" in SQL? #

sql
best-practices
performance
join

How to get the latest record in each group using GROUP BY?

sql
join
subquery
performance

Oracle: What does `(+)` do in a WHERE clause?

sql
join
best-practices
sql-99

Drop table in old version of SQLite where IF EXISTS is not supported

sql
database-management
error-handling
best-practices

Datetime equal or greater than today in MySQL

sql
datetime
mysql
date-comparisons

Multiple INNER JOIN SQL ACCESS

sql
join
best-practices
sql-optimization

Why is query with phone = N'1234' slower than phone = '1234'?

sql
performance
best-practices
indexing

What's faster, SELECT DISTINCT or GROUP BY in MySQL?

sql
performance
indexing
query-optimizer

Using IF ELSE statement based on Count to execute different Insert statements

sql
best-practices
performance
functions

Alter TABLE without locking the table?

sql
database-migration
schema-change
online-ddl

Select NOT IN multiple columns

sql
join
performance
best-practices

Mysql incorrect key file for tmp table when making multiple joins

sql
tmp-table
mysql-configuration
performance-optimization

How can I introduce multiple conditions in LIKE operator?

sql
prompt-engineering
best-practices
performance

Executing a stored procedure within a stored procedure

sql
stored-procedures
transaction-control
error-propagation

Foreign key referring to primary keys across multiple tables?

sql
database-design
data-integrity
foreign-keys

Find all stored procedures that reference a specific column in some table

sql
sql-search
database-management
stored-procedures

How to compare dates in datetime fields in Postgresql?

sql
database
postgresql
date-range-comparisons

Calculating difference between two timestamps in Oracle in milliseconds

sql
interval
timestamp-arithmetic
oracle

Sql Server giving logins(users) db_owner access to database

sql
best-practices
security
scripting