Re: Do I just not understand count()?

Perhaps it would clear up things for those more expert on SQL [and it's
variations across DBs] than I if you could say on what system you would
normally do this.


> > That's what I'd normally do to, but in this case I want to run a query
> > more like
> >
> > select count(a=1), count(a=2) from t
> >
> > > > If I have the table t defined as:
> > > >
> > > >  a
> > > > ---
> > > >  1
> > > >  1
> > > >  2
> > > >
> > > >
> > > > and I say:
> > > >
> > > > select count(a=1) from t;
> > > >
> > > > should it give me 1 or 2 as a result? I'm getting 2, and I'd think I
> > > > should get 1....
> > > >



--
Nigel J. Andrews
Director

---
Logictree Systems Limited
Computer Consultants