Re: LIMIT

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



What about 'select count(*) from aTable'

- Frank

> Is there a way to get the number of rows that would have been returned
had
> there not been a LIMIT clause in a SELECT statement?
> 
> For example, if
> Query #1) SELECT * FROM aTable
> would normally return 100 rows.  But
> Query #2) SELECT * FROM aTable LIMIT 5
> will return 5 rows.  Is there a way to find out that 100 rows would
have
> been returned if there was no LIMIT clause, by using only Query #2 and
maybe
> a PHP function on the $result?
> 
> Regards,
> Dwight
> 
> 
> -- 
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux