SQL get count per repeated value in field – Mysql
I have a table similar to the following. (The addresses are actually IP addresses, but I'm keeping them short for simplicity.) | Cust ID | Address | | ------- | --------| | 1 | 111 | | 1 | 222…
How to get element count in multiple xml files in a folder using PHP?
The following php script gives count of elements in a single xml file in the folder uploads. But I have number of xml files in the folder. What to modify in the following script so that I get result in…
mysql select count of distinct rows based on newest date and insert into another table
As the subject states, I have a table with multiple rows per user and I need to get a count of all rows for each user with the data from the row with the oldest date AND then insert one…
How to count notifications with a certain status and a certain user_id? – Mysql
enter image description here How to count notifications with a certain status and a certain user_id ? I have some data in notification table, how is the logic to calculate notification whose status is field 3 based on user_id 2…
MySQL: Counting results from multiple LEFT JOINS
I have three tables that describe data where there are some main things. Each thing can have several categories below it, and each category can have multiple segments. main main_id main_name 1 bla 2 blub categories cat_id main_id category_name 4…
SQL COUNT with conditions – Mysql
I have this table that lists which months each product is available on the market. For example product 1 is available from Mar to Dec and product 2 is available from Jan to Feb. product_id start_month end_month 1 3 12…
SQL – how to get 0 in SQL as counting result? – Mysql
I created SQL query which should count the number of e-mails sent after 20.12.2022 for each user_id from ACTIONQUEUE table. My query counts everything correctly for all users, but it doesn't returns 0 in the table for the users with…
Update unique values/combinations of concatenated columns from another table – Postgresql
I have table2 contains around 26 columns & 2mln rows. a b c d e f g h i j k l m n o p q r s t u v w x y z 18 2 2 22…
SQL get result and number of rows in the result with LIMIT – Mysql
I have a large database in which I use LIMIT in order not to fetch all the results of the query every time (It is not necessary). But I have an issue: I need to count the number of results.…
SQL get count of distinct user types in one row per date – Mysql
I have a list of countries, and for each country I have a table like this (first column: user, second column: user_type, third column: date): user user_type date user1 National 2022-10-01 user1 National 2022-10-01 user2 National 2022-10-01 user2 International 2022-10-01…