Tag: count

How to count multiple columns in SQL (Oracle) with criteria?

I’m working on SMS-Gateway that holds multiple charged SMS-services with different numbers, each SMS sent to the customer has 4 status as below (forwarded, delivered, expired,delivery failed) Now I have the below first_table for the charging-system with the below details (TABLE-A) and below (TABLE-B) wh…

SQL query cannot use NOT LIKE to get results

count redash select sql where-clause

I am starting out in SQL and am trying to do a query that will select all event names that are unique and do not have ‘TODAY-XXXXXXXX’ in the value for the event_name column. I have a query that works …

MySQL: Counting active products that belong to active categories (and optionally to active subcategories)

count left-join mysql mysql-5.6 sql

i’m using MySQL 5.6. I need to get a list of categories, with a product count column. So far, a very easy and trivial task. Here’s where it gets a little complicated: A product has a category, and can also have a subcategory (optionally). Categories, subcategories and products can be active (flg_p…

Incrementing count ONLY for duplicates in MySQL

count duplicates mysql sql window-functions

Here is my MySQL table. I updated the question by adding an ‘id’ column to it (as instructed in the comments by others). I want to add a new column called row_num to assign an incrementing number ONLY for duplicates, as shown below. Order of the results does not matter. I followed this answer and …

Counting number of occurrences of a value resulting in “Mismatched Input” error?

azure-databricks count sql

So, I have a table where a bunch of people took multiple surveys. Each survey had a rating out of 10. I need to find the average per survey (which I’ve already done) and also the number of 10s that …