SQL组通过

发布于 2025-01-26 04:48:19 字数 300 浏览 3 评论 0原文

我正在尝试列出2017年10月和年度的所有订单及其日期订单的总计按时间顺序。

但是它行不通。发生错误。对我要出错的地方有任何了解吗？试用小组和组。

这是我所拥有的：

      SELECT *
      FROM [db.name]
      WHERE record_date.YEAR =2017, record_date.MONTH =October 
      GROUP BY record_date.YEAR, record_date.MONTH
      ORDER BY ASC;

原文

I'm trying to List all orders from the month and year of October 2017 and their totals in date order
chronologically.

but it does not work. There's an error which occurs. Any insight on where i'm going wrong? Tried Group by and Group by having.

Here is what I have:

      SELECT *
      FROM [db.name]
      WHERE record_date.YEAR =2017, record_date.MONTH =October 
      GROUP BY record_date.YEAR, record_date.MONTH
      ORDER BY ASC;

分享到QQ

分享到微博