RE: SQL UBound?

2002-12-10 Thread Alford, Sean 
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=subscribeforumid=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

RE: SQL UBound?

2002-12-10 Thread Steve Reich 
Perfect! Thanks Sean.

Steve

-Original Message-
From: Alford, Sean [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 10, 2002 8:46 AM
To: CF-Talk
Subject: RE: SQL UBound?


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=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.