???????????

????????????????????1?????2 ?????3??

???????????????????δ???????????δ???????1?????2?????3.

??????????????????

????1.??????????????????????????????????????????????GROUP BY????????????￡?????????????????????????????л?????γ????

????2.?????????????????????????????

????3.????????????????????Ч??????????????????????????????

????4.??????????????????????????Σ????????????????????????????м???????????????Σ????????????????????????????????????????????????

????5.????????

????Select student_no max (decode(fileld_name?? ‘student_name’??field_value)) as student_name  fromcuc_student group by student_no;

????Student_no  --primary key

????Field_name?? filed_value: -- ??????δ???????

????Student_name -- ??δ?????????????????????????

????Cuc_student –????