Explain Codes LogoExplain Codes Logo

Sql

Can you use an alias in the WHERE clause in mysql?

sql
subqueries
aggregate-functions
aliasing

How to delete duplicate rows without unique identifier

sql
delete-duplicates
postgresql
ctid

How to query GROUP BY Month in a Year

sql
group-by
date-aggregation
sql-functions

String or binary data would be truncated. The statement has been terminated

sql
data-truncation
sql-server
database-configuration

How do I find a default constraint using INFORMATION_SCHEMA?

sql
constraint-tracing
sys-views
sql-server

Escaping ampersand character in SQL string

sql
escape-mechanisms
sql-queries
string-concatenation

How to deal with SQL column names that look like SQL keywords?

sql
sql-keywords
sql-escaping
sql-design

What are best practices for multi-language database design?

sql
database-design
multilingual-database
sql-functions

How do I count columns of a table

sql
information-schema
metadata
database-structure

Facebook database design?

sql
database-design
data-integrity
optimization

How to extract only the year from the date in SQL Server 2008?

sql
date-handling
sql-server
best-practices

How can I confirm a database is Oracle & what version it is using SQL?

sql
database-administration
sql-queries
oracle-database

Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc

sql
best-practices
performance
data-access

Finding duplicate values in a SQL table

sql
database-systems
group-by-clause
data-integrity

Oracle SQL how to remove time from date

sql
date-manipulation
sql-functions
best-practices

How to test an SQL Update statement before running it?

sql
transaction
update
sql-queries

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions

sql
pagination
offset-fetch
row-number

Mysql delete under safe mode

sql
temporary-tables
subqueries
mysql-workbench

Sql Identity (autonumber) is Incremented Even with a Transaction Rollback

sql
identity-mechanism
database-design
performance-optimization

How to rethrow the same exception in SQL Server

sql
error-handling
try-catch
transactions