回答:其中的条件判断依据自己数据中的字段进行判断,显示内容设置用HTML显示
回答:现在查询成绩已经出来了
回答:select to_char(to_date('2021-02-01','yyyy-mm-dd'),'d') rq from dual;select to_char(sysdate,'d') rq from dual; 星期天为1,星期一为2,以当前月为例,不取周日,sql如下(oracle数据库):select * from (select to_char(to_date('2021-02','yyyy-mm')+level -1,'yyyy-mm-dd') rq from dualconnect by level<= to_number(to_char(last_day(to_date('2021-02','yyyy-mm')),'dd'))) twhere to_char(to_date(rq,'yyyy-mm-dd'),'d') <> 1;
回答:用IN的关系吧,PLAN_ID in ('"+replace($Process_Plan,",","','")+"')
回答:group by这些字段就行吧 ,
回答:select case when length(a.BudgetDetailID)>0 and length(a.ProjectBudgetID)>0 then b.BudgetType = 1 else 2 end BudgetTypefrom cw_bill_budget aleft join cw_bill b on a.bill_id = b.id(关联条件确认对不对?)
6
6
0
10
没有更多