sql - SQL group by - 如何按两列分组，日期和小时

Question

请参阅下面的代码我正在尝试按 2 列分组：

select 
    "dimension.date", "dimension.hour",
    "order_name", "order_id",     
    sum("column.total_line_item_level_impressions") as total_impressions, 
    sum("column.total_line_item_level_clicks") as total_clicks
from 
    data_test.order_check
where 
    order_id = '2881013495' and "dimension.hour" = '6'
group by
    "dimension.date", "dimension.hour",

标签： sqlpostgresqlgroup-by

Answer 1

谢谢大家，下面的查询完成了工作

select
sum("column.total_line_item_level_impressions") AS total_impressions, 
sum("column.total_line_item_level_clicks") as total_clicks, 
"dimension.date"
from data_test_order_check
where order_id='2881013495' AND "dimension.hour"='6'
GROUP BY "dimension.date"