Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


how to count all rows when using select with limit in mysql query


how to count all rows when using select with limit in mysql query  using -'mysql'

I've got a mysql query like this:

SELECT A.ID, A.NAME, B.ID, B.NAME
FROM table1 A
JOIN table2 B ON ( A.ID = B.TABLE1_ID )
WHERE
    cond1, cond2, ..., condN
LIMIT 10


I've got many where clauses in query.
How to improve this query to get also full row count?
I don't want to use one more request without LIMIT.
    

asked Sep 16, 2015 by vijaygupta1980
0 votes
5 views



Related Hot Questions



Government Jobs Opening


...