The table rows can be counted using PostgreSQL's COUNT() function. It is an aggregate function that enables us to count the rows that meet the specified condition. There are multiple ways to use the COUNT() function, such as COUNT(*), COUNT(col_name), and COUNT(DISTINCT col_name). Each implementation of the COUNT() function serves a different functionality.
Let’s learn the working of the COUNT() function through Practical examples.
How to Use COUNT(*) Function in …