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
