Hey Guyz Is this possible to get total number of rows count with offset limit
Scenario
SELECT * FROM users limit 0,5;
This Query contain 300 records but the issue is if i call this query with offset the result will be show only 5 record and i don't want to write a Query in twice time. one for paging limit and other for total no of record count...
I don't want this
SELECT * FROM users limit 0,5; // paging
SELECT count(*) FROM users; // count
i have to merge this Queries or helps are definitely appreciated
No comments:
Post a Comment