Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: retrieve rows in a specified order

Re: retrieve rows in a specified order

From: Paul <paul_at_not.a.chance.ie>
Date: Sun, 21 Dec 2003 17:16:04 -0000
Message-ID: <MPG.1a4fe5aeef2e8e33989854@news1.eircom.net>

paul_at_not.a.chance.ie says...

> SELECT * FROM My_Table ORDER BY Order_By_Field

Oh, yes, and put an index on the field.

Paul...

-- 

plinehan  x__AT__x  yahoo  x__DOT__x  com

C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro

Please do not top-post.
Received on Sun Dec 21 2003 - 11:16:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US