Hi guys, I am working on creating a device listing API that supports pagination. In the SQL world, LIMIT and OFFSET seems to be the standard way of doing pagination in MySQL and PostgreSQL. Below is an example,
SELECT Device.id, Device.name FROM Device LIMIT 10 OFFSET 10 But Oracle seems to be using rownum. What's the recommended approach in doing this? Cheers~ -- Dulitha Wijewantha (Chan) Software Engineer - Mobile Development WSO2 Inc Lean.Enterprise.Middleware * ~Email duli...@wso2.com <duli...@wso2mobile.com>* * ~Mobile +94712112165* * ~Website dulitha.me <http://dulitha.me>* * ~Twitter @dulitharw <https://twitter.com/dulitharw>* *~Github @dulichan <https://github.com/dulichan>* *~SO @chan <http://stackoverflow.com/users/813471/chan>*
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev