CITY VARCHAR2(255) not null, YEAR NUMBER(4) not null, MONTH NUMBER(2) not null, SELL_AMOUNT NUMBER(26,2) ) comment on table T_TEST is '各月世联在主要核心城市的销售金额'; comment on column T_TEST.CITY is '城市'; comment on column T_TEST.SELL_AMOUNT is '比如0.42代表42%'; inser...
WHERE AR IS NOT NULL --234, ORACLE/SQL SERVER SELECT EmpName , Major , ROW_NUMBER() OVER (PARTITION BY EmpName ORDER BY Major) FldIdx FROM Specialty --236, ORACLE / SQL SERVER SELECT EmpName , MAX(CASE WHEN FldIdx=1 THEN Major END) Fld1 , MAX(CASE WHEN FldIdx=2 THEN Major EN...
Oracle:create table zjhis.mz_zdxx_zlasselect a.sfsb,wm_concat(a.zdmc) as 诊断 from zjhis.mz_zdxx agroup by a.sfsb直接可以使用 wm_concat 函数SQl SERVER :select t.patient_id, t.times, [ values ] = stuff((select ',' + icd_name from sx2017.dbo.mz_visit_diagnose where patient_...