Re: Counting Records

From: Tom Miskiewicz <miskiewicz2_at_yahoo.com>
Date: Sun, 12 Oct 2003 18:50:45 +0200
Message-ID: <bmc0qg$kpc$1@news.gatel.net>

> >What is the most efficient way of counting records in a table?
> >I want to count records in a table that match my query. How do I do that?
> >I guess that select count(1) from table_name where fieldA='something'
isn't
> >the most elegant thing I can do?

> Not elegant ... but efficient.

What do you mean? Is this how you would do it, when you would have to count records in an application?
What are the alternatives and why are those not efficient.

Thanks
Tom Received on Sun Oct 12 2003 - 11:50:45 CDT