PostgreSQL Tutorial: MOD Function
Summary: The PostgreSQL MOD() function performs the modulo operation that returns the remainder after the division of the first argument by the second one.
PostgreSQL Tutorial: NTH_VALUE Function
Summary: In this tutorial, you will learn how to use the PostgreSQL NTH_VALUE() function to get a value from the nth row in a result set.
PostgreSQL Tutorial: NTILE Function
Summary: In this tutorial, you will learn how to use the PostgreSQL NTILE() function to divide ordered rows in the partition into a specified number of ranked buckets.
PostgreSQL Tutorial: PERCENT_RANK Function
Summary: In this tutorial, you will learn how to use the PostgreSQL PERCENT_RANK() function to calculate the relative rank of a value within a set of values.
PostgreSQL Tutorial: RANK Function
Summary: In this tutorial, you will learn how to use PostgreSQL RANK() function to assign a rank for every row of a result set.
PostgreSQL Tutorial: ROUND Function
Summary: The PostgreSQL ROUND() function rounds a numeric value to its nearest integer or a number with the number of decimal places.
PostgreSQL Tutorial: ROW_NUMBER Function
Summary: In this tutorial, you will learn how to use the PostgreSQL ROW_NUMBER() function to assign a unique integer value to each row in a result set.
PostgreSQL Tutorial: TRUNC Function: Truncate Numbers to a Specified Decimal Places
Summary: The PostgreSQL TRUNC() function returns a number truncated to a whole number or truncated to the specified decimal places.
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.