If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
AVG
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); |
#2
|
|||
|
|||
AVG
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])); -- KARL DEWEY Build a little - Test a little "Octet32" wrote: 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); |
#3
|
|||
|
|||
AVG
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 .. "Octet32" wrote in message news 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); |
#4
|
|||
|
|||
AVG
Thanks
"John Spencer" wrote: 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 .. "Octet32" wrote in message news 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); |
Thread Tools | |
Display Modes | |
|
|