[ic] Highest Value In A Column

Ron Phipps interchange-users@interchange.redhat.com
Fri Apr 5 21:45:01 2002


If this is a SQL db then you can do something like:

[query sql="SELECT MAX(column_name) AS max_value FROM table" list=1]
	[seti max_value][sql-max_value][/seti]
[/query]

Max value: [scratch max_value]

-Ron

> -----Original Message-----
> From: interchange-users-admin@interchange.redhat.com
[mailto:interchange-
> users-admin@interchange.redhat.com] On Behalf Of Jim Webster
> Sent: Friday, April 05, 2002 6:07 PM
> To: interchange-users@interchange.redhat.com
> Subject: [ic] Highest Value In A Column
> 
> I'm have a column in a table and I need to display the highest #
(value)
> in
> the column.
> 
> Example:
> 
> Column Name
> 3
> 4
> 8
> 5
> 2
> 
> The highest # in Column Name is: [code here]
> 
> Obviously I need "8" to be shown.  Can someone help?
> 
> Thanks.
> 
> Jim Webster
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users@interchange.redhat.com
> http://interchange.redhat.com/mailman/listinfo/interchange-users