paul.... i do a
select ID from hTBL group by type and i still only get a single row for each type, where i would expect to get the ~5000 rows, grouped around the 3 different types. what's going on???? thanks... -bruce -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Friday, September 10, 2004 4:36 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: group by issue...?? At 16:27 -0700 9/10/04, bruce wrote: >hi... > >if i do this... > >select >h1.itemID as hitem, >h1.process as process, >h1.status as status, >h1.tblType as tbl, >h1.date as date >from historyTBL as h1 > where (h1.tblType = '3' or h1.tblType = '4'); > >i get a results table with ~5000 rows... > >if i add the 'group by' sql, > >select >h1.itemID as hitem, >h1.process as process, >h1.status as status, >h1.tblType as tbl, >h1.date as date >from historyTBL as h1 > where (h1.tblType = '3' or h1.tblType = '4') >group by tblType; <<<<<<<<<<<<<<<< > >i get a single line for each tblType... > >i was under the impression that i should get the same number of rows >returned, but that they would be grouped together..... > >can someone provide an explanation as to how this should work, and what's >going on???? If you use GROUP BY with selecting the value of any aggregate functions, you achieve the same effect as SELECT DISTINCT. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
