[{"cat_id":1,"categoryCode":"categoryCode1","categoryName":"categoryName1","cat_type":"A","description":"Mens Upper Shirt"},{"cat_id":2,"categoryCode":"categoryCode2","categoryName":"categoryName2","cat_type":"A","rank":5,"description":"Shirt"},{"cat_id":3,"categoryCode":"categoryCode3","categoryName":"categoryName3","cat_type":"Women Top wear","description":"cloths"},{"cat_id":4,"categoryCode":"categoryCode4","categoryName":"categoryName4","cat_type":"A","rank":8,"description":"Women"}]

db.collection.aggregate([{"$addFields":{"sortrank":{"$ifNull":["$rank",999]}}},{$sort:{sortrank:1}},{$project:{sortrank:false}}])