0
I only have one table and I want to count each entry of a tag starting from 0
Now I try this:
SELECT label, COUNT(start) AS Anzahl, user_id FROM datensammlung where (start='1') AND (user_id='1') GROUP BY label;
But the reward is only:
| Label | quantity | User ID |
|---|---|---|
| 1_Eating Spoon | 20 | 1 |
| 1_Blow your nose | 20 | 1 |
But I want this:
| Label | quantity | User ID |
|---|---|---|
| 1_Eating Spoon | 20 | 1 |
| 1_Blow your nose | 20 | 1 |
| 1_Telephone | 0 | 1 |
Your Answer
1 answers
0
If all label are available in the table, you can use conditional aggregation:
SELECT label,
SUM(user_id = '1' AND start = '1') AS Anzahl
FROM datensammlung
GROUP BY label; 
2024-04-07 12:09:57
Hot tools Tags
Hot Questions
How to pass an array into a SQL Server stored procedure
2026-01-31 22:24:05
What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such
2026-01-31 22:02:53
Convert a JavaScript string in dot notation into an object reference
2026-01-31 21:22:07
MySQL error #2014 - Commands out of sync; you can't run this command now [closed]
2026-01-31 21:01:19
How do I format a date in JavaScript?
2026-01-31 20:43:18
Popular tool
vc9-vc14 (32+64 bit) runtime library collection (link below)
Download the collection of runtime libraries required for phpStudy installation
VC9 32-bit
VC9 32-bit phpstudy integrated installation environment runtime library
PHP programmer toolbox full version
Programmer Toolbox v1.0 PHP Integrated Environment
VC11 32-bit
VC11 32-bit phpstudy integrated installation environment runtime library
SublimeText3 Chinese version
Chinese version, very easy to use
Hot Topics
Douyin level price list 1-75
20522
7
20522
7
wifi shows no ip assigned
13634
4
13634
4
Hot Article
What should I do if I can't always get the spot? Ouyitun Bibao multi-currency rotation and rebalancing strategy
2026-04-04
By DDD
Is the Martingale strategy effective? Detailed explanation of Ouyi DCA robot parameter setting
2026-04-03
By DDD
14 Hidden iOS 26 Features You Probably Missed
2026-04-01
By DDD
PHP runtime getting and monitoring script maximum memory limit (bytes)
2026-04-01
By DDD