Home » RDBMS Server » Server Administration » Re: Ooopps! Replace Max with Min to retrieve correct result (-)
Re: Ooopps! Replace Max with Min to retrieve correct result (-) [message #373573] Tue, 24 April 2001 05:07
lp
Messages: 8
Registered: April 2001
Junior Member
max returns maximum value after 9 ie. 14 from your table while min returns the exact result 10 what you need ie. nearest value to 9.
If you need the nearest value to 9 out of 1,4,7,10,12,14, then you need to correct it as min and not max.

Report message to a moderator

Previous Topic: Need help!!!
Next Topic: Beginner SQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Jun 29 00:12:58 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.