f the query and
it'll give you some details of the query plan.
Donna
"bruce" <[EMAIL PROTECTED]>
01/04/2007 01:45 PM
Please respond to
<[EMAIL PROTECTED]>
To
<[EMAIL PROTECTED]>
cc
Subject
RE: group by/select issue..
thanks for the derived tbl appr
having
to hit the db a number of times...
thoughts/comments/
thanks
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 04, 2007 10:01 AM
To: [EMAIL PROTECTED]
Cc: 'Chris White'; mysql@lists.mysql.com; 'Peter Bradley'
Subjec
[EMAIL PROTECTED]>
cc
"'Chris White'" <[EMAIL PROTECTED]>,
Subject
RE: group by/select issue..
hi peter
i must be missing something. the following is my actual schema. i have a
test tbl with ~2900 rows... only a few of the rows have a
27;; mysql@lists.mysql.com
Subject: Re: group by/select issue..
Bruce,
Try:
SELECT DISTINCT NAME
FROM DOG
WHERE STATUS != 3
Should do the trick.
You obviously don't want the STATUS field. If you include it, you'll
get more than one line per name. Similarly for ID. If you want
7 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: group by/select issue..
bruce wrote:
i'm trying to figure out how to create a select query that groups
the tbl around 'name' such that if i want all names that do not
have a status=3, i'd get a single row for &#
eturn the
other status that aren't equal to '3' for the given name...
-Original Message-
From: Chris White [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 04, 2007 9:07 AM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: Re: group by/select issue..
bruce wrote:
bruce wrote:
i'm trying to figure out how to create a select query that groups
the tbl around 'name' such that if i want all names that do not
have a status=3, i'd get a single row for 'sue' and 'bob'
I'm not sure why `SELECT name FROM dog WHERE status = 3 GROUP BY name;`
wouldn't give you wha
hi...
i have the following test tbl
dog
name char
statusint
idint
test data
dog
name status id
tom 1 1
tom 2 2
sue 1 3
tom 3 4
sue 2 5
bob 1 6
i'm trying
