List:General Discussion« Previous MessageNext Message »
From:Ahmad Al-Twaijiry Date:September 19 2006 2:23pm
Subject:Re: SUM in WHERE
View as plain text  
Actually is this possible with simple SQL command in Mysql ?

On 9/19/06, Price, Randall <randallp@stripped> wrote:
> I tried it also with 5.0.24-community-nt and it still didn't work!
>
> Randall Price
>
> Microsoft Implementation Group
> Secure Enterprise Computing Initiatives
> Virginia Tech Information Technology
> 1700 Pratt Drive
> Blacksburg, VA  24060
>
> Email:  Randall.Price@stripped
> Phone:  (540) 231-4396
>
> -----Original Message-----
> From: Ahmad Al-Twaijiry [mailto:ahmadt@stripped]
> Sent: Tuesday, September 19, 2006 10:06 AM
> To: Edward Macnaghten
> Cc: mysql@stripped
> Subject: Re: SUM in WHERE
>
> I tried it also with 4.1.21-log and still didn't work !
>
> On 9/19/06, Ahmad Al-Twaijiry <ahmadt@stripped> wrote:
> > I tried that before and it also doesn't work, is it because I'm using
> > mysql version 4.1.19 ?
> >
> > On 9/19/06, Edward Macnaghten <eddy@stripped> wrote:
> > > Ahmad Al-Twaijiry wrote:
> > >
> > > > Hi everyone
> > > >
> > > <snip>
> > >
> > > > SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID
> > > >
> > > >
> > >
> > > SELECT ID  FROM tbl_name GROUP BY ID HAVING SUM(Total)=100 ORDER BY
> ID
> > >
> >
> >
> >
> > --
> >
> > Ahmad Fahad AlTwaijiry
> >
>
>
> --
>
> Ahmad Fahad AlTwaijiry
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>


-- 

Ahmad Fahad AlTwaijiry
Thread
SUM in WHEREAhmad Al-Twaijiry18 Sep
  • AW: SUM in WHEREAndré Hänsel18 Sep
    • Re: SUM in WHEREAhmad Al-Twaijiry18 Sep
  • Re: SUM in WHEREEdward Macnaghten18 Sep
    • Re: SUM in WHEREAhmad Al-Twaijiry19 Sep
      • Re: SUM in WHEREAhmad Al-Twaijiry19 Sep
        • RE: SUM in WHERERandall Price19 Sep
          • Re: SUM in WHEREAhmad Al-Twaijiry19 Sep
  • Re: SUM in WHEREFelix Geerinckx21 Sep
    • Re: SUM in WHEREAhmad Al-Twaijiry24 Sep
RE: SUM in WHEREQuentin Bennett19 Sep
  • Re: SUM in WHEREDouglas Sims20 Sep
    • Re: SUM in WHEREAhmad Al-Twaijiry24 Sep
      • Re: SUM in WHEREDouglas Sims24 Sep
        • Re: SUM in WHEREAhmad Al-Twaijiry24 Sep
          • Re: SUM in WHEREDouglas Sims25 Sep
            • Re: SUM in WHEREAhmad Al-Twaijiry25 Sep
              • Re: SUM in WHEREPeter Brawley25 Sep
  • adding columns to a large tableHelen M Hudson25 Sep
    • Re: adding columns to a large tableEhrwin Mina25 Sep
      • RE: adding columns to a large tableMugunthan SIFY25 Sep
        • RE: adding columns to a large tableOw Mun Heng25 Sep
    • Re: adding columns to a large tablepraj25 Sep
  • Re: adding columns to a large tableHelen M Hudson25 Sep