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

Report message to a moderator

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()

Report message to a moderator

Previous Topic: Can Someone Look At My Procedure Please!
Next Topic: Menu Errors
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 31 05:38:46 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.