1 Reply Latest reply on Feb 13, 2017 8:44 AM by Steven Hawkins

    Count(1) vs Count(*) with group by

    Hend Amin Novice

      Hello,

      I had a query  select x, count(1) from myTable group by x;

      The count was wrong.

      However when i used  select x, count(*) from myTable group by x; the results were correct.

      What does count(1) vs count(*) do ?