mysql - 日期间隔 mysql 今天没有显示

Question

我的查询：

SELECT p.idprd, 
       p.nmprd, 
       pe.idprd, 
       pe.stockjual, 
       pe.stockkeluar, 
       pe.tothrgjual, 
       pe.tgljual 
FROM   tbproduk AS p 
INNER JOIN (
    SELECT idprd, 
        Sum(stockjual)   AS 'stockjual', 
        Sum(stockkeluar) AS 'stockkeluar', 
        Sum(tothrgajual) AS 'tothrgjual', 
        tgljual 
    FROM   tbpenjualan 
    WHERE  '2019-01-06' >= '2019-01-06' - INTERVAL 7 day 
    AND '2019-01-06' < '2019-01-06' + INTERVAL 7 day 
    GROUP  BY idprd
) AS pe ON p.idprd = pe.idprd 

我的结果

我的数据： 日期“2019-01-06”未显示。如何显示我的当前日期

标签： mysqlsql

Answer 1

GROUP BY 缺少列 - 这甚至会阻止您成功执行 SQL 语句。但是在调整 SQL 语句后，结果包括正确的数据集。

SELECT p.idprd, 
   p.nmprd, 
   pe.idprd, 
   pe.stockjual, 
   pe.stockkeluar, 
   pe.tothrgjual, 
   pe.tgljual 
FROM   tbproduk AS p 
INNER JOIN (
   SELECT idprd, 
       Sum(stockjual)   AS 'stockjual', 
       Sum(stockkeluar) AS 'stockkeluar', 
       Sum(tothrgajual) AS 'tothrgjual', 
       tgljual 
   FROM   tbpenjualan 
   WHERE  '2019-01-06' >= '2019-01-06' - INTERVAL 7 day 
   AND '2019-01-06' < '2019-01-06' + INTERVAL 7 day 
   GROUP  BY idprd, tgljual
) AS pe ON p.idprd = pe.idprd 
ORDER BY pe.tgljual desc;

查询结果：