var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Urgent: How to concatenate?
For example, I have a table contains records as follows:
ID Name Remark
1001 Sam M1234
1001 Sam N1234
1001 Sam O1234
1002 Rita X1234
1002 Rita Y1234
1002 Rita Z1234
The output I want is as follows:
select id, remark from table1 group by id
Anybody can help how to build a select statement to concatenate text of different records?
you can do it easily in sybase asa, or in mysql 4.1+
otherwise you have to write a script to loop over the result set
Do you want generic SQL-92 (complex), or for a given data engine (simpler, but non-portable)? If you want engine specific, which engine?