Tuesday, April 10, 2012

Is this possible to get total number of rows count with offset limit

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