[CLOSED] Determining Highest Value in a Column of Data
How do determine the highest number in a column of numbers? I have looked at the MAX function but it wants two fields to compare. I need to determine the maximum value in a single column of data.This message has been edited. Last edited by: Kerry,
February 24, 2009, 12:11 PM
Jinx
Try this
TABLE FILE SOMETABLE SUM MAX.SOMENUMBER END
Jinx
7.6.11 Windows HTML, PDF, Excel etc DevStudio/Webfocus/Focus IBM SQL Server 2000 / 2008 DB2
February 24, 2009, 02:41 PM
PBrightwell
You can also do TABLE FILE MYFILE SUM MYFIELD BY HIGHEST 1 MYFIELD NOPRINT END
Pat WF 7.6.8, AIX, AS400, NT AS400 FOCUS, AIX FOCUS, Oracle, DB2, JDE, Lotus Notes