Rick,
Try this: SELECT field1 FROM form ORDER BY field2 DESC; Kelvin ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Tuesday, September 16, 2008 10:16 AM To: [email protected] Subject: Help with Oracle select statement ** Am looking to get some specific syntax on a SQL call ARS 7 to Oracle 9 that would do the following: Select field1 from Form order by field2 (field2 is int field. I want the sort done highest value to lowest) Thanks! Rick __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
