MYSQL，删除数据库中的前几条

delete  from um_messagebox where cMessageBoxid in(

    select CMESSAGEBOXID

           from(

                  select A.CMESSAGEBOXID,rownum  from um_messagebox  A  ,Um_message B

                        where A.CMESSAGEID= B.Cmessageid 

                                 and A.Cmessagestate='0' 

                                and (
                                           (A.Csenduserid='674c96daae6c4a2cabb831246a23d9ee' and   A.Creceiveuserid is null) 

                                            or A.Creceiveuserid='674c96daae6c4a2cabb831246a23d9ee'
                                        )

                        order by B.Dsendtime

                 ) where rownum<2

)