Cookbook

Standard SQL PostgreSQL MS SQL Server MySQL Oracle

How to Compare Date Values in SQL

Standard SQL MS SQL Server MySQL PostgreSQL Oracle

How to Compare Datetime Values in SQL

Standard SQL

How to Insert Multiple Rows in SQL

Standard SQL

How to Select NULL Values in SQL

MS SQL Server

How to Delete Duplicate Rows in a Table in SQL Server

MS SQL Server PostgreSQL SQLite

How to Divide Columns in SQL Server, PostgreSQL, or SQLite

Oracle MySQL

How to Divide one Column by Another in MySQL or Oracle

Standard SQL

How to Use Multiple WHERE Conditions in a Single Query

PostgreSQL

How to Format a Date in PostgreSQL

Standard SQL Oracle MySQL PostgreSQL SQLite MS SQL Server

How to Check ‘Is Not Equal’ in SQL

Standard SQL MySQL PostgreSQL Oracle MS SQL Server Sqlite

How to Get all Row Combinations From Two Tables in SQL

MySQL

How to Avoid Dividing by Zero in MySQL

MySQL

How to Get the Current Date in MySQL

Oracle

How to Get the Date From a String in Oracle

MySQL

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

SQLite

How to Order by Date in SQLite

MS SQL Server

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

SQLite

How to Order by Month Name in SQLite

Standard SQL

How to Select the First Row in Each GROUP BY Group

PostgreSQL

How to Capitalize Each Words' First Letter in PostgreSQL

Standard SQL MySQL PostgreSQL MS SQL Server Oracle SQLite

How to Combine the Results of Two Queries in SQL

MS SQL Server

How to Concatenate String and NULL Values in SQL Server

MS SQL Server

How to Convert Time Data from Strings in SQL Server

PostgreSQL

How to Convert a String to a Numeric Value in PostgreSQL

MS SQL Server

How to Convert an Integer to a Decimal in SQL Server

MS SQL Server

How to Format a Date in T-SQL

Standard SQL MySQL PostgreSQL MS SQL Server Oracle SQLite

How to Order Rows by Group Sum in SQL

MySQL

How to Remove Leading Characters from a String in MySQL

MS SQL Server

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

Standard SQL MySQL PostgreSQL Oracle SQLite

How to Concatenate Strings in SQL

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

How to Find Records with NULL in a Column

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Find Rows with Maximum Value

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Find Rows with Minimum Value

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

How to Convert a String to Uppercase in SQL

How to Compare Date Values in SQL

How to Compare Datetime Values in SQL

How to Insert Multiple Rows in SQL

How to Select NULL Values in SQL

How to Delete Duplicate Rows in a Table in SQL Server

How to Divide Columns in SQL Server, PostgreSQL, or SQLite

How to Divide one Column by Another in MySQL or Oracle

How to Use Multiple WHERE Conditions in a Single Query

How to Format a Date in PostgreSQL

How to Check ‘Is Not Equal’ in SQL

How to Compare 2 Dates in the WHERE Clause in SQL

How to Format a Date in Oracle

How to Compare two Strings in MySQL

How to Compare two Strings in SQL

How to Insert a Single Quote in SQL

How to Subtract one Value From Another in SQL

How to Escape Single Quotes in SQL

How to Get the Previous Month in SQL

How to Get the Previous Month in T-SQL

How to Group by Month in MySQL

How to Group by Month in Oracle

How to Group by Month in SQLite

How to Group by Month in T-SQL

How to Check the Length of a String in SQL

How to Get Day Names in MySQL

How to Get Day Names in Oracle

How to Get Day Names in PostgreSQL

How to Get Day Names in SQL Server

How to Get Day Names in SQLite

How to Write a CASE Statement in SQL

How to Delete a Column in SQL

How to Drop a Table in SQL

How to Get the Current Date in Oracle

How to Limit Results in MySQL, PostgreSQL and SQLite

How to Limit Results in Oracle

How to Split a String in Oracle

How to Split a String in PostgreSQL

How to Split a String in SQL Server

How to Add a Column in SQL

How to Change Text to Lowercase in SQL

How to Create View 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 Get the Current Date in SQL Server

What Is the Default Constraint Name in PostgreSQL?

How to Get the Time From a String in MySQL

How to Remove Spaces From a String in MySQL

How to Sort in SQL

How to Get all Row Combinations From Two Tables in SQL

How to Avoid Dividing by Zero in MySQL

How to Get the Current Date in MySQL

How to Get the Date From a String in Oracle

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

How to Order by Date in SQLite

How to Order by Date in T-SQL

How to Order by Month Name in MySQL

How to Order by Month Name in PostgreSQL or Oracle

How to Order by Month Name in SQLite

How to Replace a New Line in Oracle

How to Split a String in MySQL

How to Use DISTINCT in SQL

How to not Show Duplicates in SQL

How to Order by Date in MySQL

How to Order by Date in PostgreSQL or Oracle

How to Comment in SQL

How to Delete a Row in SQL

How to Extract Substrings in PostgreSQL and MySQL

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

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

How to Calculate Timestamp Difference in MySQL

How to Calculate Timestamp Difference in PostgreSQL

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

How to Find the Difference Between Two Timestamps in Oracle

How to Find the Difference Between Two Timestamps in SQLite

How to Calculate Date Difference in PostgreSQL/Oracle

How to Calculate the Difference Between Two Dates in MySQL

How to Calculate the Difference Between Two Dates in SQLite

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