Ask a Question
Advertise on boostr.in
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 )
¬†¬†¬†¬†cond1, cond2, ..., condN
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.
Sep 16, 2015
to add a comment.
Related Hot Questions
Government Jobs Opening