查询语句生成序号问题

Question

 SELECT  LS_NETTEACH.CNETTEACHID,
                  LS_NETTEACH.nNetTeachActualTime,
                  LS_NETTEACH.nNetTeachActualClNum,
                  LS_NETTEACH.dNetTeachAttendClTime,
                  Ls_Netteach.cNetTeachClassroomTitle
                  FROM LEARSELF.LS_NETTEACH LS_NETTEACH
                  INNER JOIN LEARSELF.LS_NETTEACHPARTICIPANTDET LS_NETTEACHPARTICIPANTDET
                   ON LS_NETTEACH.Cuserid = LS_NETTEACHPARTICIPANTDET.Cuserid
                   and LS_NETTEACH.Cnetteachid = LS_NETTEACHPARTICIPANTDET.Cnetteachid加一列序号。用ORCL语句。大家帮帮忙哈！
             
     查询

Answer 1

 SELECT   Row_Number() OVER (partition by  LS_NETTEACH.nValidState ORDER BY LS_NETTEACH.CNETTEACHID desc),
                  LS_NETTEACH.CNETTEACHID,
                  LS_NETTEACH.nNetTeachActualTime,
                  LS_NETTEACH.nNetTeachActualClNum,
                  to_char(LS_NETTEACH.dNetTeachAttendClTime,'yyyy-mm-dd hh24:mi'),
                  Ls_Netteach.cNetTeachClassroomTitle
                  FROM LEARSELF.LS_NETTEACH LS_NETTEACH
                  INNER JOIN LEARSELF.LS_NETTEACHPARTICIPANTDET LS_NETTEACHPARTICIPANTDET
                   ON LS_NETTEACH.Cuserid = LS_NETTEACHPARTICIPANTDET.Cuserid
                   and LS_NETTEACH.Cnetteachid = LS_NETTEACHPARTICIPANTDET.Cnetteachid
                  INNER JOIN LEARSELF.LS_CONSTANT
                   ON LEARSELF.LS_NETTEACHPARTICIPANTDET.CCONSTID =
                  LEARSELF.LS_CONSTANT.CCONSTID
                   INNER JOIN umadmin.UM_USER
                  ON UM_USER.CUSERID = LS_NETTEACH.CUSERID
                  INNER JOIN umadmin.UM_SCHOOL
                    ON UM_SCHOOL.CSCHOOLID = LEARSELF.LS_NETTEACHPARTICIPANTDET.CSCHOOLID
                  INNER JOIN umadmin.UM_AREA AREA
                    ON AREA.CAREAID = UM_SCHOOL.CAREAID
                  INNER JOIN umadmin.UM_AREA CITY
                   ON AREA.CAREAPARENTCODE = CITY.CAREACODE
                  INNER JOIN umadmin.UM_AREA PROVINCE
                   ON PROVINCE.CAREACODE = CITY.CAREAPARENTCODE
                  LEFT JOIN umadmin.UM_PERIOD
                    ON UM_USER.CPERIODID = UM_PERIOD.CPERIODID
                  INNER JOIN umadmin.UM_SUBJECT
                    ON LS_NETTEACH.CSUBJECTID = UM_SUBJECT.CSUBJECTID