|
|
Posted by --CELKO-- on 10/02/67 11:50
Please post DDL, so that people do not have to guess what the keys,
constraints, Declarative Referential Integrity, data types, etc. in
your schema are. Sample data is also a good idea, along with clear
specifications. It is very hard to debug code when you do not let us
see it.
If you had followed minimal Netiquette, would you have posted something
that shows that you are dealing with sets (collective or plural names)
that have particular roles in the data model:
CREATE TABLE Students -- we doi not grade people unless we are
cannibals
(student_id INTEGER NOT NULL PRIMARY KEY,
student_name VARCHAR(35) NOT NULL)';
CREATE TABLE Grades -- in what?
(student_id INTEGER NOT NULL
REFERENCES Students (student_id)
grade_score DECIMAL (5,2) NOT NULL,
PRIMARY KEY (student_id, grade_score);
>> The data looks like this: .. <<
I HOPE NOT!! That would a disaster.
>> I'd like a query that returns the each person's [student] name along with their
highest grade. <<
Why does this smell of homework assignment. So first thing is to
answer your quesiton then track you down and report you for cheating
to your school if needed.
SELECT student_name, MAX(grade_score)
FROM Grades AS G, Students AS S
WHERE S.student_id = G.student_id ;
Navigation:
[Reply to this message]
|