我正在运行一些查询,我想将查询的输出存储为新表。我正在使用Jupyter笔记本,在那里我连接到一个sqlite数据库,该数据库包含我在查询中使用的表。你知道吗
sql2="""
create table sales_fact_unique as
(
with min_leads as
(
select LeadId, min(BookingCreateDate)as FirstBookingDate
from
sales_fact
where GrossRevenue <>0
group by
LeadId
)
select a.LeadId, a.FirstBookingDate, b.ArrivalDate,
b.DepartureDate,b.DealWonSalesPersonId,
b.GrossRevenue,b.EngineFromFinalURL,b.CampaignFromFinalUrl
from
min_leads as a
inner join
(select * from sales_fact where grossrevenue <>0 ) as b
on a.leadid=b.leadid
and a.FirstBookingDate=b.BookingCreateDate
)
;
"""
conn.execute(sql2)
conn.commit()
这是我得到的错误。你知道吗
<ipython-input-42-bc72021206b2> in <module>()
45
46
---> 47 c.execute(sql2)
48 conn.commit()
49
OperationalError: near "(": syntax error
你知道吗?你知道吗
CREATE TABLE ... AS ...需要查询,而不是子查询,因此必须删除最外面的一对括号:
相关问题 更多 >
编程相关推荐