02 2023 档案

摘要:SQL: select distinct SYSDATE as "当前系统时间", -- 获取系统时间关键字:SYSDATE a.event_no, a.Total_Drug, a.Total_Unitfrom ZOEPRES.PRES_INP_PRES_RECORD a 阅读全文
posted @ 2023-02-08 19:11 Java猿道 阅读(230) 评论(0) 推荐(0)
摘要:原SQL: select distinct a.begin_exec_time,b.drug_code,b.drug_name,b.drug_spec,sum(b.public_retail_price*a.total_drug) as "总金额",b.public_retail_price fro 阅读全文
posted @ 2023-02-07 18:10 Java猿道 阅读(397) 评论(0) 推荐(0)