Articles Cookbook

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

Finding Maximum Values in Rows

Read more

MySQL

How to Add Days to a Date in MySQL

Read more

SQL Server

How to Add Days to a Date in T-SQL

Read more

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

How to Add Time to a Datetime Value in MySQL

Read more

SQLite

How to Add a Month to a Date in SQLite

Read more

PostgreSQL

How to Capitalize the First Letter of Every Word in PostgreSQL

Read more

SQL Server

How to Change Date and Time Formats in T-SQL

Read more

MySQL

How to Change Datetime Formats in MySQL

Read more

MySQL

How to Change Seconds to a Time Value in MySQL

Read more

Standard SQL MySQL PostgreSQL SQL Server Oracle SQLite

How to Combine the Results of Two Queries in SQL

Read more

SQL Server

How to Concatenate String and NULL Values in SQL Server

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

PostgreSQL

How to Convert a String to a Date in PostgreSQL

Read more

PostgreSQL

How to Convert a String to a Numeric Value in PostgreSQL

Read more

PostgreSQL

How to Convert a String to a Timestamp in PostgreSQL

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

How to Eliminate Duplicate Rows in SQL

Read more

SQL Server

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

Read more

PostgreSQL

How to Extract the Week Number from a Date in PostgreSQL

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

How to Find Duplicate Rows in SQL?

Read more

Standard SQL PostgreSQL MS SQL Server Oracle MySQL SQLite

How to Find Minimum Values in Columns

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

How to Find the Average of a Numeric Column in SQL

Read more

PostgreSQL

How to Find the Interval Between Two Dates in PostgreSQL

Read more

MySQL

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

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

MySQL

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

Read more

Standard SQL PostgreSQL Oracle SQL Server MySQL SQLite

How to Floor Numbers in SQL

Read more

SQL Server

How to Format a Date in T-SQL

Read more

SQLite

How to Format a Datetime in SQLite

Read more

SQL Server

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

Read more

PostgreSQL

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

Read more

SQL Server

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

Read more

MySQL

How to Get the Current Date and Time in MySQL

Read more

PostgreSQL

How to Get the Current Date and Time with Time Zone Offset in PostgreSQL

Read more

PostgreSQL

How to Get the Current Date in PostgreSQL

Read more

SQLite

How to Get the Current Date in SQLite

Read more

PostgreSQL

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

Read more

PostgreSQL

How to Get the Current Time in PostgreSQL

Read more
go to top