select loginname,
ROW_NUMBER() OVER(PARTITION BY D.file_flag ORDER BY D .file_date DESC) as RN
from table where rn<5
select loginname,
ROW_NUMBER() OVER(PARTITION BY D.file_flag ORDER BY D .file_date DESC) as RN
from table where rn<5