|
bharath405
Starting Member
India
2 Posts |
 Posted - 10/31/2012 : 04:24:06
|
Hello All,
I need an SQL query which combines two rows of a same table into single row without altering number of columns
Please have a look into the example
columns id TEXTID L9 L7 L10 L12 L16
L9,L7,L10,L12,L16 1 1Error Störung Error Incident Disturbo
L9,L7,L10,L12,L16 8 8 Alarm Alarm Alarma Alarme Allarme
expected output should be
columns id TEXTID L9 L7 L10 L12 L16
L9,L7,L10,L12,L16 1 1 Error_Alarm Störung_Alarm Error_Alarma Incident_Alarme Disturbo_Allarme
K BHARATH KUMAR REDDY |
|
Merging two rows of an SQL table into single row
