PostgreSQL Tutorial: SELECT DISTINCT
Summary: in this tutorial, you will learn how to use the PostgreSQL SELECT DISTINCT clause to remove duplicate rows from a result set returned by a query.
PostgreSQL Tutorial: Self-Join
Summary: in this tutorial, you will learn how to use the PostgreSQL self-join technique to compare rows within the same table.
PostgreSQL Tutorial: Table Aliases
Summary: in this tutorial, you will learn about the PostgreSQL table aliases and their practical applications.
PostgreSQL Tutorial: UNION: Combining Result Sets of Multiple Queries
Summary: in this tutorial, you will learn how to use PostgreSQL UNION operator to combine result sets of multiple queries into a single result sets.
PostgreSQL Tutorial: ARRAY_AGG Function
Summary: In this tutorial, you will learn how to use the PostgreSQL ARRAY_AGG() aggregate function to return an array from a set of input values.
PostgreSQL Tutorial: AVG Function
Summary: In this tutorial, you will learn how to use PostgreSQL AVG() function to calculate the average value of a set.
PostgreSQL Tutorial: Creating Updatable Views Using the WITH CHECK OPTION Clause
Summary: In this tutorial, we will show you how to create an updatable view using the WITH CHECK OPTION clause to ensure that the changes to the base tables through the view satisfy the view-defining condition.
PostgreSQL Tutorial: Drop View
Summary: In this tutorial, you will learn how to use the PostgreSQL DROP VIEW statement to remove one or more views from the database.
PostgreSQL Tutorial: Managing Views
Summary: In this tutorial, you will learn about views and how to manage views in PostgreSQL.
PostgreSQL Tutorial: Materialized Views
Summary: This tutorial introduces you to PostgreSQL materialized views that allow you to store the result of a query physically and update the data periodically.