How to count the values in a column (Enterprise Manager)

To count the values in a column

1. Start the query by adding the table you want to summarize to the Diagram pane.
2. Right-click anywhere in the Diagram, Grid, or SQL panes, and choose Group By. The Query Designer adds a Group By column to the grid in the Grid pane.
3. Add the column that you want to count to the Grid pane.

   The Query Designer automatically fills the term Group By into the Group By column of the grid.

4. Change Group By in the Group By column to Count.

   - Or -

   To count only unique values, choose Count Distinct.