Cookbook

MySQL

How to Add Days to a Date in MySQL

SQL Server

How to Add Days to a Date in T-SQL

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Add Ranking Positions of Rows in SQL with RANK()

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Add Ranking Positions to Rows with DENSE_RANK() in SQL

MySQL

How to Add Time to a Datetime Value in MySQL

SQLite

How to Add a Month to a Date in SQLite

MySQL Oracle SQL Server PostgreSQL

How to Calculate a Square Root in SQL

MySQL Oracle SQL Server PostgreSQL

How to Calculate a Square in SQL

SQL Server

How to Calculate a Square in SQL Server

MySQL

How to Calculate the Difference Between Two Dates in MySQL

PostgreSQL Oracle

How to Calculate the Difference Between Two Dates in PostgreSQL/Oracle

SQLite

How to Calculate the Difference Between Two Dates in SQLite

T-SQL

How to Calculate the Difference Between Two Dates in T-SQL

T-SQL

How to Calculate the Difference Between Two Datetimes in T-SQL

MySQL

How to Calculate the Difference Between Two Timestamps in MySQL

Oracle

How to Calculate the Difference Between Two Timestamps in Oracle

PostgreSQL

How to Calculate the Difference Between Two Timestamps in PostgreSQL

SQLite

How to Calculate the Difference Between Two Timestamps in SQLite

PostgreSQL

How to Capitalize the First Letter of Every Word in PostgreSQL

SQL Server

How to Change Date and Time Formats in T-SQL

MySQL

How to Change Datetime Formats in MySQL

MySQL

How to Change Seconds to a Time Value in MySQL

Standard SQL MySQL PostgreSQL SQL Server Oracle SQLite

How to Combine the Results of Two Queries in SQL

PostgreSQL T-SQL SQLite Oracle MySQL

How to Comment in SQL

Standard SQL T-SQL PostgreSQL SQLite Oracle MySQL

How to Compute an Absolute Value in SQL

SQL Server

How to Concatenate String and NULL Values in SQL Server

Standard SQL MySQL PostgreSQL Oracle SQLite

How to Concatenate Strings in SQL

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Convert a String to Lowercase in SQL

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Convert a String to Uppercase in SQL

PostgreSQL

How to Convert a String to a Date in PostgreSQL

PostgreSQL

How to Convert a String to a Numeric Value in PostgreSQL

PostgreSQL

How to Convert a String to a Timestamp in PostgreSQL

SQL Server Oracle MySQL PostgreSQL SQLite

How to Convert an Integer to a Decimal in SQL Server

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Count Distinct Values in SQL

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Count the Number of Rows in a Table in SQL

Standard SQL MySQL PostgreSQL Oracle SQL Server SQLite

How to Create One Table From Another Table in SQL

Standard SQL MySQL PostgreSQL Oracle SQL Server

How to Create a Primary Key in SQL

Standard SQL MySQL PostgreSQL Oracle SQL Server SQLite

How to Create a Table from an SQL Query

Standard SQL MySQL PostgreSQL Oracle SQL Server

How to Create a Table with a Foreign Key in SQL

Standard SQL MySQL PostgreSQL Oracle SQL Server

How to Delete a Foreign Key Constraint in SQL

MySQL Oracle SQL Server PostgreSQL SQLite

How to Delete a Row in SQL

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Eliminate Duplicate Rows in SQL

Oracle SQLite

How to Extract a Substring From a String in Oracle/SQLite

PostgreSQL MySQL

How to Extract a Substring From a String in PostgreSQL/MySQL

T-SQL

How to Extract a Substring From a String in T-SQL

SQL Server

How to Extract or Convert Time Data from a String in SQL Server

PostgreSQL

How to Extract the Week Number from a Date in PostgreSQL

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Filter Records with Aggregate Function AVG

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Filter Records with Aggregate Function COUNT

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Filter Records with Aggregate Function SUM