RE: SQL

[Alford, Gary]

<cfquery name="myquery" datasource="odbc">     SELECT    *     FROM    TABLE </cfquery>   <cfoutput query="myquery" startrow="5" maxrows="5">     ... </cfoutput>   ============================================ Gary L. Alford Supplier Product Assurance Bell Helicopter Textron Phone: (817) 280-6233 Fax: (817) 278-6233 mailto:[EMAIL PROTECTED] ============================================ -----Original Message----- From: Gregory Price [mailto:[EMAIL PROTECTED]] Sent: Monday, October 15, 2001 12:29 PM To: [EMAIL PROTECTED] Subject: OT: SQL does anyone know how to get a single row in a select statement in sql say I want to grab the 5th row in some table regardless of its contense, i just want the 5th record any help is appreciated! Thanks Greg Price