PROTECTED]
Subject:Distinct Selects...
Q: I have the following table "grades":
+++
| name | score |
+++
| Joh
Use GROUP BY
SELECT names, score FROM grades GROUP BY names
regards,
-- Andrew
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, March 27, 2001 11:14 AM
Subject: Distinct Selects...
> Q: I have the followin
select name, score from grades group by name;
Cal
http://www.calevans.com
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 10:14 AM
To: [EMAIL PROTECTED]
Subject: Distinct Selects...
Q: I have the following table "g
Q: I have the following table "grades":
+++
| name | score |
+++
| John |10 |
+++
| John | 8 |
+++
| Carl |10 |
+++
| Mary |6 |
+++
I want to select
