Top "Count" questions

Count refers to the number of objects in a collection.

Selecting distinct values from two tables

I have two rather large databases (+1 million rows each). Both tables have the same structure. How can I check if …

mysql count distinct multiple-tables
Count number of subsets with sum equal to k

Given an array we need to find out the count of number of subsets having sum exactly equal to a …

algorithm count subset-sum
simplest, shortest way to count capital letters in a string with php?

I am looking for the shortest, simplest and most elegant way to count the number of capital letters in a …

php count letters
Oracle Query: Get distinct names having count greater than a threshold

I have a table having schema given below EmpID,MachineID,Timestamp 1, A,01-Nov-13 2, A,02-Nov-13 3, C,03-Nov-13 1, B,02-Nov-13 1, C,04…

oracle count group-by distinct having-clause
Count leading zeroes in an Int32

How do I count the leading zeroes in an Int32? So what I want to do is write a function …

c# count int bit-manipulation leading-zero
How to count cells in a range with a value less than another cell in excel?

My Table looks like below if "team1" value is less than "general" value in that month, then it has blue …

excel count excel-formula conditional-formatting
JPA 2.0: count for arbitrary CriteriaQuery?

I am trying to implement the following convenience method: /** * Counts the number of results of a search. * @param criteria The …

orm jpa count jpa-2.0 criteria-api
Hibernate Criteria and Count Column

I am trying to return an entity with a column that has the count of another table that is a …

hibernate count subquery hibernate-criteria
SQL Count where clause

I have the the following SQL statement: SELECT [l.LeagueId] AS LeagueId, [l.LeagueName] AS NAME, [lp.PositionId] FROM (Leagues …

sql join count where-clause having
Mysql count frequency

I've checked similar questions but it didnt help in my precise question. So, my table goes like this: id age 1 30 2 36 3 30 4 52 5 52 6 30 7 36 …

mysql arrays count frequency