SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 09:17 PM
| ||||
| ||||
 Re: SUM in WHERE Actually is this possible with simple SQL command in Mysql ? On 9/19/06, Price, Randall <randallp@vt.edu> 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@vt.edu > Phone: (540) 231-4396 > > -----Original Message----- > From: Ahmad Al-Twaijiry [mailto:ahmadt@gmail.com] > Sent: Tuesday, September 19, 2006 10:06 AM > To: Edward Macnaghten > Cc: mysql@lists.mysql.com > 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@gmail.com> 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@edlsystems.com> 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=Randall.Price@vt.edu > > -- Ahmad Fahad AlTwaijiry      |
Linear Mode
