我正在尝试从tempTable2获取总行数,但错误显示“关系"temptable2”不存在“ select
(
select count(*) from tempTable2
where (EXTRACT(EPOCH FROM (maxdailylog - mindailylog))/3600)>4.5
) as totalHadir,
(
select count(*) from tempTable2
where (EXTRACT(EPOCH FROM (maxdailylog - mindailylog))/3600)<4.