Hi @kgarigipati, Hah, Thanks for the reply. If I use head 1, I will get only one row. I need to get all the records that has the date 2020-10-21. And the date is not a constant, it varies, and I need a dynamic way to capture that date and filter out the other records that share the same date. The example here has two such rows. But the actual data has a bigger row count, the number of attributes I may get, varies by process. If there is an alternate way, by which i can capture the records that were last indexed based on the same date column, that solution too would be way too helpful.
... View more