List:General Discussion« Previous MessageNext Message »
From:Vivek Khera Date:April 2 1999 6:48pm
Subject:Re: Counting rows returned from a SELECT with perl DBI.
View as plain text  
>>>>> "BS" == Brian Seitz <bds215@stripped> writes:

BS> Oh, sorry.  I forgot to mention that my SELECT statement has about five
BS> WHERE conditions in it, so I know that COUNT(*) doesn't work. 
BS> Basically, I suppose I'm asking how can I get the same functionality of
BS> COUNT that works with WHERE conditions?

You're looking for the COUNT(*) function.  But you already found it,
just aren't using it.  What makes you think COUNT(*) won't work with a
WHERE clause?

I'd recommend going out and getting a good book on SQL if you're not
sure of these things.


								v.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera@stripped       Rockville, MD       +1-301-545-6996
PGP & MIME spoken here            http://www.kciLink.com/home/khera/
Thread
Counting rows returned from a SELECT with perl DBI.Brian Seitz2 Apr
  • Re: Counting rows returned from a SELECT with perl DBI.Sasha Pachev2 Apr
  • Re: Counting rows returned from a SELECT with perl DBI.Brian Seitz2 Apr
    • Re: Counting rows returned from a SELECT with perl DBI.Vivek Khera2 Apr
  • Re: Counting rows returned from a SELECT with perl DBI.Daniel Koch2 Apr
  • Re: Counting rows returned from a SELECT with perl DBI.Douglas Brantz3 Apr
  • Counting rows returned from a SELECT with perl DBI.Michael Widenius3 Apr