Wrox Programmer Forums
Go Back   Wrox Programmer Forums > PHP/MySQL > MySQL
|
MySQL General discussion about the MySQL database.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the MySQL section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old January 22nd, 2004, 11:52 AM
Registered User
 
Join Date: Jan 2004
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default get max test score and corresponding date

Hi

i have a table
with columns

student_number,
test1score,
test1date,
test2score,
test2date,
test3score,
test3date

i need to select the max(test1score) and the corresponding test1date
max(test2score) and corresponding test2date and the max(test3score) and corresponding test3date
all in one single query

also no restrictions on number of times a student takes a test
and test scores and dates can be NULL.

anyone any tips ?
 
Old January 24th, 2004, 08:42 PM
Authorized User
 
Join Date: Nov 2003
Posts: 43
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to bjackman Send a message via MSN to bjackman
Default

I posted a reply to you in the access forum.






Similar Threads
Thread Thread Starter Forum Replies Last Post
Algorithm to Score Global Quality-Quantity of File asgarcymed VBScript 0 November 24th, 2007 11:12 PM
Max Date kristina Crystal Reports 1 July 10th, 2005 09:03 AM
Display highest test score kgs51 VB.NET 2002/2003 Basics 15 November 19th, 2004 11:02 AM
Coursebuilder Score Script fs22 Javascript 0 April 8th, 2004 09:37 AM
quiz total score frenziedsilence Beginning PHP 2 January 14th, 2004 12:22 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.