Try
SELECT name, min(score) FROM grades
GROUP BY name;
--Greg Johnson
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 27, 2001 11:14 AM
To: [EMAIL PROTECTED
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 following table "grades":
>
> +++
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 "grades":
+
