> AVG

O

Octet32

Im try to find out which stuents had a greater then avg grade how do i write
this?

I tryed the below no luck.

SELECT studentname
FROM students
WHERE grade = > AVG (grade);
 
K

KARL DEWEY

Try these two queries ----
Grade_AVG ---
SELECT Avg(Students.grade) AS AvgOfgrade
FROM Students;

SELECT Students.StudentName, Students.grade
FROM Students, Grade_AVG
WHERE (((Students.grade)>=[AvgOfgrade]));
 
J

John Spencer

I would think that the following would give you the result you say you want.

SELECT StudentName
FROM Students
WHERE Students.Grade >=
(SELECT Avg(Grade)
FROM Students)



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
O

Octet32

Thanks

John Spencer said:
I would think that the following would give you the result you say you want.

SELECT StudentName
FROM Students
WHERE Students.Grade >=
(SELECT Avg(Grade)
FROM Students)



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
Click to expand...
 
Top