Count gives the returns the count of distinct rows while count all returns the value of rows including duplicates.