Re: Counting Records

Tom Miskiewicz wrote:

>Hello!
>
>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?
>
>
>Thanks
>Tom
>
>

Not elegant ... but efficient.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)