'MariaDB error an alias was previously found
What's wrong? There is a "count" in red in the code. I get the data when I run the code, but it crashes after refreshing. count= I count the data in the previous column(numb5).
SELECT `id`, `numb1`, `numb2`, `numb3`, `numb4`, `numb5`, COUNT(`id`) over(partition by `numb5`) AS `count`
FROM billing
p.s. numb5 = numb3+numb4
Server version: 10.4.22-MariaDB
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|