摘要： 函数 row_number()row_number() over (partition by patient_id /*需要分组的列*/ order by zyid /*排序的列*/)sqlSELECT ZYID, patient_id ,row_number() over (partition by patient_id order by zyid) visit_id from jk_patient_in_hospitaloraclecreate or replace view adminp_view_info asselect "ZYID","PATIENT_ 阅读全文