Top "Count" questions

How can I do a count distinct in sqlite?

I have a table: ref,type 1,red 2,red 3,green 4,blue 5,black 6,black I want the result of a sqlite query …

sqlite count sum distinct

Facebook Graph API - Get like count on page/group photos

I've been testing graph API and ran into a problem. How can I get like count from photos of a …

facebook facebook-graph-api count facebook-like photos

MongoDB 'count()' is very slow. How do we refine/work around with it?

I am currently using MongoDB with millions of data records. I discovered one thing that's pretty annoying. When I use …

performance mongodb count

In MongoDB's pymongo, how do I do a count()?

for post in db.datasets.find({"test_set":"abc"}).sort("abc",pymongo.DESCENDING).skip((page-1)*num).limit(num): This is …

mongodb count pymongo database

C# EPPlus OpenXML count rows

With EPPlus and OpenXML does anyone know the syntax on how to count the rows? Say my worksheet is called "…

c# excel count openxml

How can I find the number of unique characters in a string?

I have found nothing particular for this purpose. I am trying to figure out a function that counts each of …

c count character charactercount

Power BI, DAX--How do I count rows in one table based on values in another table?

I have two tables, lets call them Table1 and Table2. Table1 has a column of unique values, Table2 has a …

count powerbi dax

Count occurrences of given character per cell

Question For example if I wanted to count the number of Ns in a column of strings how can I …

google-sheets count character bioinformatics

How can you use COUNT() in a comparison in a SELECT CASE clause in Sql Server?

Let's say you want do something along the following lines: SELECT CASE WHEN (SELECT COUNT(id) FROM table WHERE column2 = 4) &…

sql sql-server count aggregate-functions select-case

How to count non-empty entries in a PHP array?

Consider: [name] => Array ( [1] => name#1 [2] => name#2 [3] => name#3 [4] => name#4 [5] => [6] => [7] => [8] => [9] => ) $name = $_POST['name'] …

php arrays count