How to get distinct counts in vb.net

Question

How do I get a distinct count using the code below:

  Command1.CommandText = "SELECT Count(account_no) FROM fphistory " &
                                "WHERE arr_date <= '12/31/2021'"

        Try
            Invoke(Sub() Total = Convert.ToInt32(Command1.ExecuteScalar))
        Catch SqlExceptionErr As SqlException
            MessageBox.Show(SqlExceptionErr.Message)
        End Try

Any help would be appreciated.

Answer 1

If you need a count of distinct numbers, then try 'SELECT Count(distinct account_no) FROM ...'.