LearnSQL.com

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

Finding Maximum Values in Rows

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

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

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

How to Eliminate Duplicate Rows 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 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 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

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

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Floor Numbers in SQL

Standard SQL PostgreSQL MS SQL Server Oracle

How to Handle Divide by Zero 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

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

How to Order by Count in SQL?

Standard SQL PostgreSQL Oracle MS SQL Server MySQL SQLite

How to Replace Part of a String in SQL

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 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

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Use LIKE in SQL

MS SQL Server

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

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

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