Karthi Keyan

Karthi Keyan

  • 1.5k
  • 750
  • 208k

about sql

Dec 18 2015 6:55 AM
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 (vinithkarthi7@gmail.com) or rly in this blog.

Answers (8)