Get the Row Count from an Outer Table Join
James Knicely, Vertica Field Chief Technologist
October 22, 2019
Aggregate functions summarize data over groups of rows from a query result set. When using an aggregate function like COUNT with an "*" or "1" parameter value, you may get a different result when the query implements a LEFT join verses an INNER join. If you want a row count of just the rows from...