about sql

Question

sir i want your help,

i am having table name marks, and col names as subjects and total,

the marks are inserted in the table like as below,

            tamil          80

            english      80

            maths       80

            science     80 like this.

but i want to merge this as a single row like,

           tamil 80; english 80; maths 80; science 80.

 

is this possible, if yes means kindly send query to my mail id ([email protected]) or rly in this blog.