Articles Cookbook

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

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

Read more

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

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

Read more

MySQL Oracle SQL Server PostgreSQL

How to Calculate a Square Root in SQL

Read more

MySQL Oracle SQL Server PostgreSQL

How to Calculate a Square in SQL

Read more

Standard SQL MySQL PostgreSQL SQL Server Oracle SQLite

How to Combine the Results of Two Queries in SQL

Read more

PostgreSQL T-SQL SQLite Oracle MySQL

How to Comment in SQL

Read more

Standard SQL T-SQL PostgreSQL SQLite Oracle MySQL

How to Compute an Absolute Value in SQL

Read more

Standard SQL MySQL PostgreSQL Oracle SQLite

How to Concatenate Strings in SQL

Read more

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Convert a String to Lowercase in SQL

Read more

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Convert a String to Uppercase in SQL

Read more

SQL Server Oracle MySQL PostgreSQL SQLite

How to Convert an Integer to a Decimal in SQL Server

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 Count the Number of Rows in a Table in SQL

Read more

Standard SQL MySQL PostgreSQL Oracle SQL Server SQLite

How to Create One Table From Another Table in SQL

Read more

Standard SQL MySQL PostgreSQL Oracle SQL Server

How to Create a Primary Key in SQL

Read more

Standard SQL MySQL PostgreSQL Oracle SQL Server SQLite

How to Create a Table from an SQL Query

Read more

Standard SQL MySQL PostgreSQL Oracle SQL Server

How to Create a Table with a Foreign Key in SQL

Read more

Standard SQL MySQL PostgreSQL Oracle SQL Server

How to Delete a Foreign Key Constraint in SQL

Read more

MySQL Oracle SQL Server PostgreSQL SQLite

How to Delete a Row in SQL

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

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