Steve,
I think you are looking for the aggregate function max().
SELECT MAX(COL) FROM TBL
Sean
-----Original Message-----
From: Steve Reich [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 8:37 AM
To: CF-Talk
Subject: SQL UBound?
I'm looking for the SQL function that will return the highest value in a
column. I have a field that is the datatype 'decimal' and I want to return
the record with the highest value in that column. Can someone help me?
Thanks,
Steve
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
