Top "Count" questions

SQL - CASE WHEN count different values

I need to show how many different values every 'id' has. It should look like this: id | component_a | component_…

sql oracle count having case-when

Count property vs Count() method?

Working with a collection I have the two ways of getting the count of objects; Count (the property) and Count() (…

c# linq list collections count

Query with LEFT JOIN not returning rows for count of 0

I am trying to get the following to return a count for every organization using a left join in PostgreSQL, …

sql postgresql count left-join

Count letters in a word in python debug

I am trying to count the number of times 'e' appears in a word. def has_no_e(word): #counts …

python count letter

Count occurrences of a value in a column of an array of object arrays

Does anyone know how to count the occurrences of "photo" in this array: Array ( [0] => stdClass Object ( [type] => photo […

php facebook-graph-api multidimensional-array count find-occurrences

Ruby: How to count the number of times a string appears in another string?

I'm trying to count the number of times a string appears in another string. I know you can count the …

ruby string count

Find the average of two combined columns in sql

I want to find the avg of the total of two columns. I want to count the total of col1 …

mysql sql count average

how to count new lines in a very big string?

The problem reduces to counting \n characters, so is there a function that can do it on a huge strings, …

php string count

Count + IIF - Access query

Employees of the company are divided into categories A, B and C regardless of the division they work in (Finance, …

sql ms-access count iif

python - find the occurrence of the word in a file

I am trying to find the count of words that occured in a file. I have a text file (TEST.…

python file count word