Can some one ping SQL Query which helps to find the records going onto the Remainder Path for a particular journey?

If you want to know the records of the remaining paths, update a Marketing Cloud contact record in Journey Builder using the "update contact" activity. And you can query the DE.