You can access data in a given partition using the $partition system function.

here is a clean example...

https://database.guide/return-all-rows-from-a-specific-partition-in-sql-server-t-sql/