Home » Developer & Programmer » Forms » To find Greatest
To find Greatest [message #80239] Wed, 28 August 2002 07:52 Go to next message
Victoria
Messages: 152
Registered: July 2002
Senior Member
Hi,
I have one cursor fetching 100 columns per row.
all are same datatype.
Now i want to find the greatest & least value in the fetched columns for each row.....
Can any one tell me the simplest way to do that???
Thanks in advance
Victoria
Re: To find Greatest [message #80249 is a reply to message #80239] Thu, 29 August 2002 06:26 Go to previous message
Sushil
Messages: 16
Registered: October 2000
Junior Member
Use GREATEST(col,col2,col3....) in select statement and as well with LEAST()
Previous Topic: Can Someone Look At My Procedure Please!
Next Topic: Menu Errors
Goto Forum:
  


Current Time: Sat Mar 02 10:54:07 CST 2024