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 (vinithkarthi7@gmail.com) or rly in this blog.

Tapan Dubey · Answer

Hii You can try like below - CREATE TABLE tblSUBJECTMarks ( Subject Varchar(50) Marks INT ) INSERT INTO tblSUBJECTMarks values('tamil'80) INSERT INTO tblSUBJECTMarks values('english'70) INSERT INTO tblSUBJECTMarks values('maths'60) INSERT INTO tblSUBJECTMarks values('science'90) SELECT * FROM( SELECT SubjectMarks FROM tblSUBJECTMarks ) a PIVOT ( sum(Marks) for Subject in ([tamil][english][maths][science]) ) a o/p will be --

Rajeesh Menoth · Answer

Hi SELECT ( ColumnA+ ' ' + ColumnB ) AS FullName FROM Table

Rajeesh Menoth · Answer

Hi If any of the answer is helpful.Then accept it.It will help for others..

Karthi Keyan · Answer

Hi... I got the Query... SELECT STUFF ((select ''+ [Subjects] + [Mark] from Marks FOR XML PATH(''))11'') as mark Thanks For Your Support

Rajeesh Menoth · Answer

Hi Check the updated answer... Reference : http://raresql.com/tag/merge-or-combine-multiple-rows-records-to-single-column-record-with-comma-delimiters/

Karthi Keyan · Answer

Hi... subject and marks are diff cols. i wrote the query to combine cols its coming like tam=80 eng=80 mat=80 but i want like tam=80eng=80mat=80.. everything in single row.

Rajeesh Menoth · Answer

Hi It combine all columns value to single. Reference : http://raresql.com/tag/merge-or-combine-multiple-rows-records-to-single-column-record-with-comma-delimiters/

Karthi Keyan · Answer

yes i found that.. but how to combine rows