Maximum value from different fields of the same record

  • Thread starter Thread starter Vandana Rola
  • Start date Start date
V

Vandana Rola

Hi,

I am trying to write a query that will find minimum/maximum value from
different fields of the same record. e.g. if students have taken three
tests, we want to drop the lowest score of each student and get two
highest scores.

Thanks
 
The test scores should be in a separate table linked back to the students
table by the student ID. Include other relevant data to the test, such as
the test date. Once you do this, all the test scores will be in the same
field and you can find the min and max.
 
Back
Top