Oracle SQL Developer查询未按字母顺序排序

debugcn 发表于 Dev

哈南·沙特

我的查询：

SELECT 
    pmmr.REQUEST_NO, pmmr.item_code itemCode, Pmmr.Form_No Form_No, 
    NVL(Pmf.Form_Name, Pmmr.Form_No) formName, pmmr.MRN, 
    NVL(p.FIRST_NAME || DECODE(p.FAMILY_NAME, NULL, '', ' ' || p.FAMILY_NAME),pmmr.MRN) PATIENT_NAME,
    pmmr.ASSIGNED_TO, pmmr.DRUG_GENERIC_NAME, pmmr.LAST_STATUS, 
    NVL(initcap(( hr1.FIRST_NAME || ' ' ||  hr1.LAST_NAME)), pmmr.LAST_PERFORMER_ID) LastActionBy,
    NVL(hr2.DEPARTMENT || ' - ' || hr2.SECTION_NAME,'') ORGANIZATION_UNIT, 
    NVL(initcap(( hr2.FIRST_NAME || ' ' || hr2.LAST_NAME)), pmmr.REQUESTER_ID) RequesterName, 
    pmmr.REQUEST_DATE
FROM 
    inhouse_apps.PHRM_MFRP_MEDICATION_REQUEST pmmr
LEFT OUTER JOIN 
    inhouse_apps.Hr_Employee hr1 ON Pmmr.Last_Performer_Id = Hr1.Employee_Number
LEFT OUTER JOIN 
    inhouse_apps.Hr_Employee hr2 ON inhouse_apps.Pmmr.Requester_Id = Hr2.Employee_Number
LEFT OUTER JOIN 
    EAPPTMT.PATIENT p ON inhouse_apps.Pmmr.Mrn = P.Mrn
LEFT OUTER JOIN 
    inhouse_apps.Phrm_Mfrp_Form pmf ON Pmmr.Form_No = Pmf.Form_No;
WHERE 
    LAST_STATUS IN ('Approved')
    AND Pmmr.Form_No = 2
ORDER BY 
    pmmr.DRUG_GENERIC_NAME ASC

我需要DRUG_GENERIC_NAME按字母顺序排序，但它不返回排序后的结果。

编辑：如下所述，需要删除分号，仅此而已

MDO

您有分号“;” 在“ Where子句”之前。您需要从那里删除它，以使Oracle同时考虑您的“ Where子句”和“ Order by子句”

SELECT pmmr.REQUEST_NO, pmmr.item_code itemCode, Pmmr.Form_No Form_No, nvl(Pmf.Form_Name, Pmmr.Form_No) formName, pmmr.MRN, nvl  (p.FIRST_NAME || DECODE(p.FAMILY_NAME, NULL, '', ' ' || p.FAMILY_NAME),pmmr.MRN)  PATIENT_NAME,pmmr.ASSIGNED_TO,
              pmmr.DRUG_GENERIC_NAME,pmmr.LAST_STATUS, nvl(initcap(( hr1.FIRST_NAME || ' ' ||  hr1.LAST_NAME)),pmmr.LAST_PERFORMER_ID) LastActionBy,
              nvl(hr2.DEPARTMENT || ' - ' || hr2.SECTION_NAME,'') ORGANIZATION_UNIT, nvl(initcap(( hr2.FIRST_NAME || ' ' || hr2.LAST_NAME)),pmmr.REQUESTER_ID) RequesterName, pmmr.REQUEST_DATE
              FROM inhouse_apps.PHRM_MFRP_MEDICATION_REQUEST pmmr
              left outer join inhouse_apps.Hr_Employee hr1 on Pmmr.Last_Performer_Id = Hr1.Employee_Number
              left outer join inhouse_apps.Hr_Employee hr2 on inhouse_apps.Pmmr.Requester_Id = Hr2.Employee_Number
              left outer join EAPPTMT.PATIENT p on inhouse_apps.Pmmr.Mrn = P.Mrn
              left outer join inhouse_apps.Phrm_Mfrp_Form pmf on Pmmr.Form_No = Pmf.Form_No
         WHERE LAST_STATUS IN ('Approved')
                  and Pmmr.Form_No = 2
          order by pmmr.DRUG_GENERIC_NAME ASC
          ;

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。