|
Posted by D.B. on 05/20/06 15:27
i'm trying to get total rows found by query that uses top clause...
for example:
select top 10 myTable.* from myTable where myTable.number > 200
let's say there are 13 rows matching that condition, and by using
@@rowcount my result would be: 10.
is there any way to get total row count, without affecting the TOP
clause??? i believe that the mysql equivalent would be
SQL_CALC_FOUND_ROWS().
tnx...
Navigation:
[Reply to this message]
|