Articles Cookbook

Standard SQL PostgreSQL MS SQL Server MySQL Oracle

How to Compare Date Values in SQL

Read more

Standard SQL MS SQL Server MySQL PostgreSQL Oracle

How to Compare Datetime Values in SQL

Read more

Standard SQL Oracle MySQL PostgreSQL SQLite MS SQL Server

How to Check ‘Is Not Equal’ in SQL

Read more

Oracle MS SQL Server PostgreSQL MySQL SQLite

How to Compare 2 Dates in the WHERE Clause in SQL

Read more

SQLite PostgreSQL MS SQL Server Oracle

How to Compare two Strings in SQL

Read more

Standard SQL Oracle MySQL PostgreSQL SQLite MS SQL Server

How to Insert a Single Quote in SQL

Read more

Standard SQL Oracle MySQL PostgreSQL SQLite MS SQL Server

How to Subtract one Value From Another in SQL

Read more

Oracle MS SQL Server MySQL PostgreSQL

How to Escape Single Quotes in SQL

Read more

Oracle MS SQL Server MySQL PostgreSQL

How to Get the Previous Month in SQL

Read more

Standard SQL MySQL PostgreSQL MS SQL Server Oracle

How to Delete a Column in SQL

Read more

Standard SQL MySQL PostgreSQL Oracle MS SQL Server

How to Drop a Table in SQL

Read more

Standard SQL MySQL PostgreSQL MS SQL Server Oracle

How to Add a Column in SQL

Read more

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

How to Change Text to Lowercase in SQL

Read more

Standard SQL MySQL PostgreSQL Oracle MS SQL Server

How to Create a Table with a Foreign Key in SQL

Read more

Standard SQL MySQL PostgreSQL Oracle MS SQL Server

How to Delete a Foreign Key Constraint in SQL

Read more

MS SQL Server MySQL PostgreSQL Oracle SQLite

How to Group by Two Columns in SQL

Read more

MySQL Oracle MS SQL Server PostgreSQL

How to Calculate a Square Root in SQL

Read more

MySQL Oracle PostgreSQL

How to Group by Year in SQL

Read more

Standard SQL PostgreSQL Oracle MySQL MS SQL Server

How to Make a Column Unique in SQL?

Read more

Standard SQL PostgreSQL Oracle MS SQL Server

How to remove a unique constraint in SQL?

Read more

MySQL Oracle MS SQL Server PostgreSQL

How to Calculate a Square in SQL

Read more

Standard SQL MS SQL Server PostgreSQL SQLite Oracle MySQL

How to Compute an Absolute Value in SQL

Read more

Standard SQL MySQL PostgreSQL MS SQL Server Oracle SQLite

How to Combine the Results of Two Queries in SQL

Read more

MS SQL Server Oracle MySQL PostgreSQL SQLite

How to Convert an Integer to a Decimal in SQL Server

Read more

Standard SQL MySQL PostgreSQL MS SQL Server Oracle SQLite

How to Order Rows by Group Sum in SQL

Read more

Standard SQL MySQL PostgreSQL Oracle SQLite

How to Concatenate Strings in SQL

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Filter Records with Aggregate Function AVG

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Filter Records with Aggregate Function COUNT

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Filter Records with Aggregate Function SUM

Read more

Standard SQL MySQL PostgreSQL Oracle MS SQL Server SQLite

How to Filter Rows without NULL in a column

Read more

Standard SQL MySQL PostgreSQL Oracle MS SQL Server SQLite

How to Find Records with NULL in a Column

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Find Rows with Maximum Value

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Find Rows with Minimum Value

Read more

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

How to Convert a String to Uppercase in SQL

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MS SQL Server MySQL SQLite

How to Find the Average of a Numeric Column in SQL

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

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

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Find the Minimum Value of a Column in SQL

Read more

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

How to Number Rows in SQL

Read more

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

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

Read more

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

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

Read more

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

How to Floor Numbers in SQL

Read more

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

How to Round Numbers in SQL

Read more

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

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

Read more

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

How to Use LIKE in SQL

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

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

Read more

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

How to Replace Part of a String in SQL

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Sum Values of a Column in SQL?

Read more

Standard SQL PostgreSQL Oracle MySQL

How to Trim Strings in SQL

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Count Distinct Values in SQL

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Eliminate Duplicate Rows in SQL

Read more

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Find Duplicate Rows in SQL?

Read more

Standard SQL PostgreSQL MS SQL Server Oracle

How to Handle Divide by Zero In SQL

Read more

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Join on Multiple Columns

Read more

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Multiply Two Columns in SQL

Read more

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Order By Two Columns in SQL?

Read more

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Order by Count in SQL?

Read more

Standard SQL MySQL MS SQL Server PostgreSQL Oracle SQLite

How to Order Alphabetically in SQL

Read more