SQL : row_number

SELECT * FROM
(
  select Date, IdNo ,DrFlag, Other
  row_number() over (PARTITION BY IdNo order by  DrFlag  desc , Other )  as RN   
  from TABLENAME
  where Date='20090901'
) TMP
WHERE RN=1 
ORDER BY IdNo