Question : This question already has answers here: How to write sql statement for following scenario? (2 answers) Closed 7 […]
Tag: distinct
Counting unique (distinct) users per day
Question : I am new topsql and am interested in counting the number of unique first time users per day. […]
distinct description
Question : I have the following database: id | remote_id | title | description ————————————- 1 | 12341234 | test […]
Why do two identical strings have a different length but the same binary value?
Question : I am trying to return a distinct set of department names from a table – nothing special. However, […]
Distinct counts from large table are too slow
Question : I have a table with 1.2 billion rows. The table has 60-70 columns, the vast majority of which […]
Distinct on two columns, how to rid from ‘duplicates’
Question : I have a table with messages, that have ‘msg_from’ and ‘msg_to’ fields. when I want to select all […]
Grouping based on the status, then count its product and the total based on its category ID
Question : I have a table with product ID, category ID and status of the product. +———+————-+————-+ | id | […]
Distinct 3 columns and 4th column with sum [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Too localized – this could be because […]
MongodB cumulated conditionnal array:using map/reduce or aggregation
Question : First, I aplogized because I have some problem to formalized my question so any idea on express it […]
Count all rows for each DISTINCT
Question : How can count all rows of WHERE statement: SELECT DISTINCT column1 FROM table COUNT WHERE date::text LIKE ‘%2014%’; […]