> AVG

[Guest]

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);

 

[Guest]

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]));

 

[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
..

 

[Guest]

Thanks

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
..