Top "Count" questions

Query for count of distinct values in a rolling date range

I have a data set of email addresses and dates that those email addresses were added to a table. There …

sql postgresql date count rolling-computation

Divide count by count(*) in SQL Server

Here is my query : SELECT COUNT(*) AS total, COUNT(CASE WHEN t.id IS NULL THEN 1 END) AS nb_null, …

sql sql-server count alias divide

Count occurrences of values

I have a column of text values with repeated values. I want to create a new column of unique values (…

excel count excel-formula pivot-table countif

DB2 SQL: How to 'count' the amount of records returned by a having clause

Table XRDK/WHSHIPP_R3 has 4 columns - ZNWHSE, ZNSITE, ZNMANE, ZNRECD with a total of 1,071 records. I have isolated the …

sql count db2 having totals

COUNT results from SQL Query with a HAVING clause

Are you able to use COUNT in a query with a HAVING clause so that the COUNT returns the number …

sql sql-server count greatest-n-per-group

R How to count occurrences of values across multiple columns of a data frame and save the columnwise counts from a particular value as a new row?

I have a large data-frame (approx 1,000 rows and 30,000 columns) that looks like this: chr pos sample1 sample2 sample3 sample 4 1 5050 1 NA 0 0.5 1 6300 1 0 0.5 1 1 7825 1 0 0.5 1 1 8200 0.5 0.5 0 1 …

r count find-occurrences

Spring Batch - Counting Processed Rows

So I am creating a Spring Batch job for reading a CSV file and for certain rows which contain incomplete …

spring count rows spring-batch

how to count space in a text statement in php

how can we count space between text in php ? example: hi how are you? spaces: 3 is there any way to …

php text count spaces

how to count the seconds in java?

I'm trying to understand how I could go about keeping track of the seconds that an object has been created …

java count seconds

Select top distinct results ordered by frequency

My table has two columns: id and name. The data looks like this: id | name ---------- 1 Jeff 2 Sam 3 Carl 4 Sam 5 …

sql mysql count distinct