SELECT orbkn_surgery_procedures_order_status,orbkn_surgery_procedures_id,orbkn_surgery_procedures_or_booking,orbkn_surgery_procedures_created_date_time,orbkn_surgery_procedures_order_id FROM OR_Cube_for_surgeryorbkn_surgery_procedures_order_statu
Therapy area Procedures1 Procedures2 Procedures3Oncologyarea'] == 'Oncology' and x['Procedures1'] > 1000: return 4
if x['Therapy area'] != 'Oncology' and x['<
我正在链接两个表,procedures和tbl_syn_procedure。只有一个条件可以让我的医生总数(用户总数),那就是procedures.phys_id = '##',但是我不知道如何将它合并到查询中。 tbl_syn_procedure.name AS 'Synoptic', FROM proceduresJOIN tbl_syn_proc
我想写一个过程,它接受两个日期作为输入(一个持续时间),并更新开始日期在此持续时间内的每个每周报告的佣金金额。佣金金额是销售额与佣金率(%)的乘积。(p_start IN WEEKLY_SALES_REPORT.StartDate%TYPE, p_end IN ISUPDATE WEEKLY_SALES_REPORT SET ComAmount = SaleAmount*ComRate wher