Click here to Skip to main content
15,347,685 members
Home / Discussions / Database
   

Database

 
QuestionMYSQL SUM SEVERAL COLUMN VALUES Pin
KipkoechE17-Feb-15 10:29
MemberKipkoechE17-Feb-15 10:29 
AnswerRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
Richard Andrew x6417-Feb-15 11:13
professionalRichard Andrew x6417-Feb-15 11:13 
GeneralRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
KipkoechE17-Feb-15 17:47
MemberKipkoechE17-Feb-15 17:47 
AnswerRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
Richard Andrew x6418-Feb-15 4:58
professionalRichard Andrew x6418-Feb-15 4:58 
GeneralRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
KipkoechE18-Feb-15 11:30
MemberKipkoechE18-Feb-15 11:30 
GeneralRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
Richard Andrew x6419-Feb-15 4:55
professionalRichard Andrew x6419-Feb-15 4:55 
GeneralRe: MYSQL SUM SEVERAL COLUMN VALUES Pin
KipkoechE19-Feb-15 19:45
MemberKipkoechE19-Feb-15 19:45 
QuestionSQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 2:35
MemberSwap917-Feb-15 2:35 
Column1 Column2
-------- ----------
Vaugh William
Vaugh Smith
Woods Jane

Expected Output :
Vaugh, William-Smith/Woods,Jane

Condition : There could be n number of rows in the sample table, there could be n number of woods too.
display all the common surname having different names meaning repeated Last names will be once then all the first names associated with it.
truncated at 30 characters max.

How can I get this output in SQL query ?
SuggestionRe: SQL server 12: Displaying column cell values in single cell Pin
ZurdoDev17-Feb-15 2:54
professionalZurdoDev17-Feb-15 2:54 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 2:58
MemberSwap917-Feb-15 2:58 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
ZurdoDev17-Feb-15 3:00
professionalZurdoDev17-Feb-15 3:00 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 3:15
MemberSwap917-Feb-15 3:15 
AnswerRe: SQL server 12: Displaying column cell values in single cell Pin
ZurdoDev17-Feb-15 3:24
professionalZurdoDev17-Feb-15 3:24 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 3:40
MemberSwap917-Feb-15 3:40 
QuestionRe: SQL server 12: Displaying column cell values in single cell Pin
Eddy Vluggen17-Feb-15 4:38
professionalEddy Vluggen17-Feb-15 4:38 
AnswerRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 4:01
mveRichard Deeming17-Feb-15 4:01 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 5:16
MemberSwap917-Feb-15 5:16 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 5:22
mveRichard Deeming17-Feb-15 5:22 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 5:36
MemberSwap917-Feb-15 5:36 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 5:44
mveRichard Deeming17-Feb-15 5:44 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 5:51
MemberSwap917-Feb-15 5:51 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 5:59
mveRichard Deeming17-Feb-15 5:59 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Richard Deeming17-Feb-15 10:23
mveRichard Deeming17-Feb-15 10:23 
GeneralRe: SQL server 12: Displaying column cell values in single cell Pin
Swap917-Feb-15 21:49
MemberSwap917-Feb-15 21:49 
QuestionSQL Optimization Pin
Chaminda Bandara16-Feb-15 20:59
professionalChaminda Bandara16-Feb-15 20:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.