sql如何设置临时表

 

--创建临时表
SELECT (select count(*) from ssss_ccbs_ac_water_meter cm where cm.ssss_sso_case_no=c.ssss_codcaseId)ssss_no_of_ccbs_ac, c.ssss_codcaseId
into ssss_codcase_temp_0524 FROM ssss_codcase c 

--删除临时表
drop table ssss_codcase_temp_0524