sql 统计我的消息列表

select * from tblUserMessage where id in(
SELECT id FROM (
SELECT id, sendUserId, userId,ROW_NUMBER() over(partition by sendUserId,userId order by id DESC) TRNUM  FROM (
SELECT id,sendUserId ,userId  FROM tblUserMessage WHERE sendUserId=1 and NumMsgType=0
UNION
SELECT id,userId AS S,sendUserId AS R FROM tblUserMessage WHERE userId=1 and NumMsgType=0
)A  
)B WHERE TRNUM=1
) ORDER BY id