Re: mysql - count records after ORDER BY

[Peter Brawley]

> Two tables are joined and I added the code to count records.

The query you post is confusing. To join tables a and b and count the result would be, minimally ...

select count(*) from (
select a.aid,b.bid
from a
join b on a.aid=b.bid
) x;

> The issue is that I want to first ORDER BY SN and assign cnt after?

Unclear. So is the query you post. Please post a clear complete statement of your query requirement.