All Questions
2 questions
0
votes
1
answer
53
views
Filling empty MySQL Result
I want to have a continuos date set with the sales.
SELECT *,
UNIX_TIMESTAMP(calendar.datefield) * 1000 AS time,
IFNULL(Sum(mos + mosnk), 0) AS mosfinal,
IFNULL(Sum(neukunden),...
- 15
8
votes
2
answers
9k
views
SQL GROUP BY with "default values"
I'm trying to create SELECT statement with a GROUP BY clause, which should return "default values".
Imagine the following simple MySQL table:
CREATE TABLE `tracker` (
`id` INTEGER PRIMARY KEY ...
- 6,868