Cookbook

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 PostgreSQL Oracle SQL Server MySQL SQLite

How to Change Text to Lowercase in SQL

Standard SQL PostgreSQL Oracle MySQL SQLite

How to Check the Length of a String in SQL

Oracle SQL Server PostgreSQL MySQL SQLite

How to Check ‘Is Not Equal’ in SQL

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

Oracle SQL Server PostgreSQL MySQL SQLite

How to Compare 2 Dates in the WHERE Clause in SQL

MySQL

How to Compare two Strings in MySQL

SQLite PostgreSQL SQL Server Oracle SQL

How to Compare two Strings 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 SQL Server Oracle

How to Create View 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 SQL Server Oracle

How to Delete a Column in SQL

Standard SQL MySQL PostgreSQL Oracle SQL Server

How to Delete a Foreign Key Constraint in SQL

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

Standard SQL MySQL PostgreSQL Oracle MS SQL Server SQLite

How to Filter Rows without NULL in a column

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Find Duplicate Rows in SQL?

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Find Maximum Values in Rows

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Find Minimum Values in Columns

Standard SQL MySQL PostgreSQL Oracle MS SQL Server SQLite

How to Find Records with NULL in a Column

Standard SQL PostgreSQL MS SQL Server Oracle SQL Server MySQL SQLite

How to Find the Average of a Numeric Column in SQL

PostgreSQL

How to Find the Interval Between Two Dates in PostgreSQL

MySQL

How to Find the Last Day of the Month for a Given Date in MySQL

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Find the Maximum Value of a Numeric Column in SQL

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Find the Minimum Value of a Column in SQL

MySQL

How to Find the Name of a Constraint in MySQL

Oracle

How to Find the Name of a Constraint in Oracle

PostgreSQL

How to Find the Name of a Constraint in PostgreSQL

SQL Server

How to Find the Name of a Constraint in SQL Server

MySQL

How to Find the Number of Days Between Two Dates in MySQL

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Floor Numbers in SQL

Oracle

How to Format a Date in Oracle

PostgreSQL

How to Format a Date in PostgreSQL

SQL Server

How to Format a Date in T-SQL

SQLite

How to Format a Datetime in SQLite

MySQL

How to Get Day Names in MySQL

Oracle

How to Get Day Names in Oracle

PostgreSQL

How to Get Day Names in PostgreSQL

SQL Server

How to Get Day Names in SQL Server

SQLite

How to Get Day Names in SQLite

MySQL

How to Get Yesterday’s Date in MySQL

Oracle

How to Get Yesterday’s Date in Oracle

PostgreSQL

How to Get Yesterday’s Date in PostgreSQL

SQLite

How to Get Yesterday’s Date in SQLite

SQL Server

How to Get Yesterday’s Date in T-SQL

PostgreSQL Oracle MySQL

How to Get a Remainder Using MOD() in PostgreSQL, MS SQL Server, and MySQL

MySQL PostgreSQL Oracle SQL Server Sqlite

How to Get all Possible Combinations of Rows From two Tables in SQL

SQL Server

How to Get the Current Date (Without Time) in T-SQL

PostgreSQL

How to Get the Current Date and Time (Without Time Zone) in PostgreSQL

SQL Server

How to Get the Current Date and Time (Without Time Zone) in T-SQL

MySQL

How to Get the Current Date and Time in MySQL

MySQL

How to Get the Date from a Datetime Column in MySQL

SQL Server

How to Get the Day from a Date in T-SQL

PostgreSQL

How to Get the Day of the Year from a Date in PostgreSQL

SQL Server

How to Get the Last Day of the Month in T-SQL

MySQL

How to Get the Month from a Date in MySQL

SQL Server

How to Get the Month from a Date in T-SQL

SQL Server

How to Get the Previous Month in T-SQL

MySQL

How to Get the Time From a String in MySQL

MySQL

How to Get the Year and the Month From a Date in MySQL

SQL Server

How to Get the Year from a Date in T-SQL

MySQL

How to Get the Year from a Datetime Column in MySQL

MySQL

How to Group by Month in MySQL

Oracle

How to Group by Month in Oracle

PostgreSQL

How to Group by Month in PostgreSQL

SQLite

How to Group by Month in SQLite

SQL Server

How to Group by Month in T-SQL

T-SQL MySQL PostgreSQL Oracle SQLite

How to Group by Two Columns in SQL

MySQL Oracle PostgreSQL

How to Group by Year in SQL

T-SQL

How to Group by Year in T-SQL

Standard SQL PostgreSQL MS SQL Server Oracle

How to Handle Divide by Zero In SQL

Standard SQL Oracle MySQL PostgreSQL SQLite SQL Server

How to Insert a Single Quote in SQL

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Join Multiple (3+) Tables in One Statement

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Join on Multiple Columns

MySQL, PostgreSQL, SQLite

How to Limit Results in MySQL, PostgreSQL and SQLite

Oracle

How to Limit Results in Oracle

T-SQL

How to Limit Results in T-SQL

MySQL

How to Limit Rows in a MySQL Result Set

SQL Server

How to Limit Rows in a SQL Server Result Set

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Multiply Two Columns in SQL

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Number Rows in SQL

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Order Alphabetically in SQL

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Order By Two Columns in SQL?

Standard SQL MySQL PostgreSQL SQL Server Oracle SQLite

How to Order Rows by Group Sum in SQL

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Order by Count in SQL?

MySQL

How to Order by Date in MySQL

PostgreSQL Oracle

How to Order by Date in PostgreSQL or Oracle

SQLite

How to Order by Date in SQLite

T-SQL

How to Order by Date in T-SQL

MySQL

How to Order by Month Name in MySQL

PostgreSQL Oracle

How to Order by Month Name in PostgreSQL or Oracle

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Round Numbers in SQL

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Round Up a Number to the Nearest Integer in SQL

Standard SQL

How to Select the First Row in Each GROUP BY Group

MySQL PostgreSQL Oracle SQL Server SQLite

How to Sort in SQL

MySQL

How to Split a String in MySQL

Oracle

How to Split a String in Oracle

PostgreSQL

How to Split a String in PostgreSQL

SQL Server

How to Split a String in SQL Server

SQL Server

How to Subtract 30 Days from a Date in T-SQL

Standard SQL Oracle MySQL PostgreSQL SQLite SQL Server

How to Subtract one Value From Another in SQL

Standard SQL Oracle MySQL PostgreSQL SQLite SQL Server

How to Subtract one Value From Another in SQL

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Sum Values of a Column in SQL?

Standard SQL PostgreSQL Oracle MySQL

How to Trim Strings in SQL

SQLite

How to Trim a String in SQLite

MySQL Oracle MS SQL PostgreSQL

How to Use DISTINCT in SQL

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Use LIKE in SQL

PostgreSQL T-SQL MySQL Oracle SQLite

How to Write a CASE Statement in SQL

Standard SQL PostgreSQL Oracle MySQL SQL Server

How to make a column unique in SQL?

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to not Show Duplicates in SQL

Standard SQL PostgreSQL Oracle SQL Server

How to remove a unique constraint in SQL?

MS SQL Server

How to remove leading and/or trailing spaces of a string in T-SQL

PostgreSQL SQL Server MySQL SQLite

The Remainder in PostgreSQL, MS SQL Server, MySQL, and SQLite

MySQL

What Is the Default Constraint Name in MySQL?

Oracle

What Is the Default Constraint Name in Oracle?

PostgreSQL

What Is the Default Constraint Name in PostgreSQL?

SQL Server

What Is the Default Constraint Name in SQL Server?

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

What’s the Difference Between RANK and DENSE_RANK in SQL?

How to Add Days to a Date in MySQL

How to Add Days to a Date in T-SQL

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

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

How to Add Time to a Datetime Value in MySQL

How to Add a Column in SQL

How to Add a Month to a Date in SQLite

How to Avoid Dividing by Zero in MySQL

How to Calculate a Square Root in SQL

How to Calculate a Square in SQL

How to Calculate a Square in SQL Server

How to Calculate the Difference Between Two Dates in MySQL

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

How to Calculate the Difference Between Two Dates in SQLite

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

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

How to Calculate the Difference Between Two Timestamps in MySQL

How to Calculate the Difference Between Two Timestamps in Oracle

How to Calculate the Difference Between Two Timestamps in PostgreSQL

How to Calculate the Difference Between Two Timestamps in SQLite

How to Capitalize the First Letter of Every Word in PostgreSQL

How to Change Date and Time Formats in T-SQL

How to Change Datetime Formats in MySQL

How to Change Seconds to a Time Value in MySQL

How to Change Text to Lowercase in SQL

How to Check the Length of a String in SQL

How to Check ‘Is Not Equal’ in SQL

How to Combine the Results of Two Queries in SQL

How to Comment in SQL

How to Compare 2 Dates in the WHERE Clause in SQL

How to Compare two Strings in MySQL

How to Compare two Strings in SQL

How to Compute an Absolute Value in SQL

How to Concatenate String and NULL Values in SQL Server

How to Concatenate Strings in SQL

How to Convert a String to Lowercase in SQL

How to Convert a String to Uppercase in SQL

How to Convert a String to a Date in PostgreSQL

How to Convert a String to a Numeric Value in PostgreSQL

How to Convert a String to a Timestamp in PostgreSQL

How to Convert an Integer to a Decimal in SQL Server

How to Count Distinct Values in SQL

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

How to Create One Table From Another Table in SQL

How to Create View in SQL

How to Create a Primary Key in SQL

How to Create a Table from an SQL Query

How to Create a Table with a Foreign Key in SQL

How to Delete a Column in SQL

How to Delete a Foreign Key Constraint in SQL

How to Delete a Row in SQL

How to Drop a Table in SQL

How to Eliminate Duplicate Rows in SQL

How to Escape Single Quotes in SQL

How to Escape Single Quotes in SQL

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

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

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

How to Extract a Substring in MySQL

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

How to Extract the Week Number from a Date in PostgreSQL

How to Filter Records with Aggregate Function AVG

How to Filter Records with Aggregate Function COUNT

How to Filter Records with Aggregate Function SUM

How to Filter Rows without NULL in a column

How to Find Duplicate Rows in SQL?

How to Find Maximum Values in Rows

How to Find Minimum Values in Columns

How to Find Records with NULL in a Column

How to Find the Average of a Numeric Column in SQL

How to Find the Interval Between Two Dates in PostgreSQL

How to Find the Last Day of the Month for a Given Date in MySQL

How to Find the Maximum Value of a Numeric Column in SQL

How to Find the Minimum Value of a Column in SQL

How to Find the Name of a Constraint in MySQL

How to Find the Name of a Constraint in Oracle

How to Find the Name of a Constraint in PostgreSQL

How to Find the Name of a Constraint in SQL Server

How to Find the Number of Days Between Two Dates in MySQL

How to Floor Numbers in SQL