Limiting a Query by Column Value: A Deep Dive into Various Approaches and Considerations for Pagination and Two Rows per Group Limitation