Explain techniques for implementing pagination in SQL queries, including LIMIT-OFFSET, ROW_NUMBER(), and cursor-based pagination.