insert entries into new table by ascending order??

[dr_overload]

Is there a way I can select data from one table and enter that data into another table by descending order of one of colums from table one?

Basically table one is a list of players with scores and I want to create a league table in a seperate table where the first row is the player with the highest score - can this be done?

Thanks
Jon

[cgraz]

insert into <your table> (field1, field2) 
   select field1
     , field2
    from <your_table2>  

   order
      by field1 desc

Why do you need a separate table where the first row is the player with the highest score? The location of the highest score is irrelevant; it can be in the middle of your table. You can most likely calculate all of this information on the fly easily from your original table.

[dr_overload]

hi cgraz

Thanks for your reply, basically I want to create league positions and into them into the DB.