Jesús Orozco and zhang！
Thank you very much ,I'll try it!
======= 2005-03-08 17:47:00 ：=======
>Hi again,
>
>I forgot something. I should create new table based on the selection...
>I think this is it:
>
>SELECT * FROM FOO ORDER BY BAR INTO NEW_FOO;
>
>COMMIT TABLE NEW_FOO AS "C:\NEW_FOO.TAB"
>
>Bye,
>JO
>
>Jesús Orozco wrote:
>
>>Hi Gao,
>>
>>You shoud make a query and then save it. Here, FOO is your table and BAR
>>is the order column. The final c:\foo.tab will be sorted upon the column
>>value in BAR.
>>
>>SELECT * FROM FOO ORDER BY BAR;
>>
>>COMMIT TABLE FOO AS "C:\FOO.TAB"
>>
>>Regards,
>>Jesús Orozco
>>
>>Gao Lang wrote:
>>
>>
>>
>>>Hi,Good evening！
>>>
>>> Does anyone know how to order a table by rows
>>>"Alter Table mytable Order columnname " is only for column!
>>>
>>>
>>>
>>>B.R
>>>
>>>
>>>Gao Lang
>>>[EMAIL PROTECTED]
>>>2005-03-08
>>>
>>>
>>>
>>>---------------------------------------------------------------------
>>>List hosting provided by Directions Magazine | www.directionsmag.com |
>>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>>For additional commands, e-mail: [EMAIL PROTECTED]
>>>Message number: 15601
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>---------------------------------------------------------------------
>>List hosting provided by Directions Magazine | www.directionsmag.com |
>>To unsubscribe, e-mail: [EMAIL PROTECTED]
>>For additional commands, e-mail: [EMAIL PROTECTED]
>>Message number: 15602
>>
>>
>>
>>
>
>
>---------------------------------------------------------------------
>List hosting provided by Directions Magazine | www.directionsmag.com |
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>Message number: 15603
= = = = = = = = = = = = = = = = = = = =
Gao Lang
[EMAIL PROTECTED]
2005-03-09
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15604
