select exam_staff.staff_name as 錄入醫生,
nvl(exam_item.item_name, '') as 檢查專案
--sum(dict_exam_item.workload) as 作業量,
--sum(cost) as "金額(元)"
from v_exams, exam_staff, exam_item, dict_exam_item
where v_exams.Exam_No = exam_staff.Exam_No
and v_exams.exam_no = exam_item.exam_no
and exam_item.item_code = dict_exam_item.item_code
and v_exams.exam_class = '超聲'
and exam_status >= '60'
and exam_item.item_name is not null
And v_exams.Exam_Class = '超聲'
And v_exams.Exam_Date = '2019-05-31'
--group by exam_staff.staff_name,exam_item.item_name
order by exam_staff.staff_name,exam_item.item_name
uj5u.com熱心網友回復：
目測沒有問題的，樓主發個截圖上來。uj5u.com熱心網友回復：
order by那里把exam_item.item_name改成nvl(exam_item.item_name, '')，試下轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/43245.html
標籤：基礎和管理
上一篇：rac 連接 freenas iscsi報錯 rac1 iscsid: Kernel reported iSCSI connection 3:0 error
下一篇：資料庫問題