How to set query to apply paging in SQL Query to get records?

1.	How to set query to apply paging in SQL Query to get records?
Answer» How to set QUERY to apply paging in SQL Query to get records? We can use SQL Query which helps us to apply paging without WORRY about the frontend setting. Below is the query which helps you to apply paging In above query we use "OFFSET 10 ROWS" to START records from 10 ROW. And "FETCH NEXT 10 ROWS ONLY" will return 10 next records. We can increase "OFFSET 10 Rows" to jump to next 10 records.

Discussion