select - Change column in sql -

i have table match:

id  (int) id_match (int) id_player (int) attend   (bit) goals (int)

when write

select * match

i have this:

       id   id_match    id_player  attend   goals 1       69    1            10       1         2 2       70    1            11       0         0

and want have this:

id_player id_match  attend  goals     10       1        1       2

have idea?

try :

 select top 1 id_player ,id_match ,attend  ,goals table_name order id asc

EXIT