Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

Confused about MIN() and MAX()...

Jan 22, 2003, 2:29 AM
Andy
Veteran / Moderator (17297 posts)
Andy's avatar
Jan 22, 2003, 2:29 AM
Post #1 of 5
Views: 980
Shortcut
Quote Reply
Confused about MIN() and MAX()...
Ok...this has me a little confused. The MySQL Manual (on group by) has the following to say;

Quote:
mysql> SELECT student_name, MIN(test_score), MAX(test_score)
-> FROM student
-> GROUP BY student_name;

Is this saying that both MIN() and MAX() have to be defined?

All I want/need to do is get the MAX() number held in the 'Weight' field Unsure It would really help now, and in future stuff if I could understand how this worked...as it looks like it could be as useful as the WHERE clause Smile

Cheers in advance.

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Jan 22, 2003, 2:35 AM
Paul
Veteran (19537 posts)
Jan 22, 2003, 2:35 AM
Post #2 of 5
Views: 968
Shortcut
Quote Reply
Re: [Andy] Confused about MIN() and MAX()... In reply to
SELECT MAX(Weight) FROM table
Jan 22, 2003, 2:48 AM
Andy
Veteran / Moderator (17297 posts)
Andy's avatar
Jan 22, 2003, 2:48 AM
Post #3 of 5
Views: 962
Shortcut
Quote Reply
Re: [Paul] Confused about MIN() and MAX()... In reply to
So there is no way to do what I want in one query, like below?

SELECT * FROM Users WHERE Weight <= MAX(Weight)

Unsure

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates
Jan 22, 2003, 2:53 AM
Paul
Veteran (19537 posts)
Jan 22, 2003, 2:53 AM
Post #4 of 5
Views: 962
Shortcut
Quote Reply
Re: [Andy] Confused about MIN() and MAX()... In reply to
Well for starters that where clause (if it were to work) is exactly the same as:

select * from Users

...as every row will of course be less or equal to the max weight.

Last edited by:

Paul: Jan 22, 2003, 2:54 AM
Jan 22, 2003, 2:58 AM
Andy
Veteran / Moderator (17297 posts)
Andy's avatar
Jan 22, 2003, 2:58 AM
Post #5 of 5
Views: 957
Shortcut
Quote Reply
Re: [Paul] Confused about MIN() and MAX()... In reply to
Ok, < MAX(Weight)

Wink

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates