SQL Server data help

[sqlhelp]

Hello

 

How to pull two columns data into a single column while the third column is common in T-SQL?

Ila undi data 

ID    Firstname  Lastname   Persongroup 

123     Chitti          Babu            123  

345     Raj              Krish           123

567     Hero           Man           123

 

Naku  Raj Krish , Hero Man  ani Kavalli output 

 

Subquery tho try chesa but raledhu

[AndhraneedSCS]

select firstname + ' ' + Lastname  from tablename 

[Sarvapindi]

15 minutes ago, sqlhelp said:

Hello

 

How to pull two columns data into a single column while the third column is common in T-SQL?

Ila undi data 

ID    Firstname  Lastname   Persongroup 

123     Chitti          Babu            123  

345     Raj              Krish           123

567     Hero           Man           123

 

Naku  Raj Krish , Hero Man  ani Kavalli output 

 

Subquery tho try chesa but raledhu

chitto babu em papam sesad va..

[MuPaGuNa]

https://stackoverflow.com/questions/20284528/how-to-concat-two-columns-into-one-with-the-existing-column-name-in-mysql/20285571

just concatenate aani kotta , vachindi..konchem google cheyi vuncle t

[Desi_guy]

1 hour ago, sqlhelp said:

Hello

 

How to pull two columns data into a single column while the third column is common in T-SQL?

Ila undi data 

ID    Firstname  Lastname   Persongroup 

123     Chitti          Babu            123  

345     Raj              Krish           123

567     Hero           Man           123

 

Naku  Raj Krish , Hero Man  ani Kavalli output 

 

Subquery tho try chesa but raledhu

question idena..deeniki Subquery kuda na

[gunturfriends]

25 minutes ago, Desi_guy said:

question idena..deeniki Subquery kuda na

search listagg function in google..i think its called stuff function in sql server

[soodhilodaaram]

50 minutes ago, Desi_guy said:

question idena..deeniki Subquery kuda na

subject weak unnapudu subquery vadite enti tappu.. aha enti tappu antunna

[xano917]

2 hours ago, sqlhelp said:

Hello

 

How to pull two columns data into a single column while the third column is common in T-SQL?

Ila undi data 

ID    Firstname  Lastname   Persongroup 

123     Chitti          Babu            123  

345     Raj              Krish           123

567     Hero           Man           123

 

Naku  Raj Krish , Hero Man  ani Kavalli output 

 

Subquery tho try chesa but raledhu

what is your role in job dude ? Non technical role ani e question veyyi good responses vasthayi.

SQL lo ABCDs aduguthunnav andhuke telling

[Desi_guy]

30 minutes ago, soodhilodaaram said:

subject weak unnapudu subquery vadite enti tappu.. aha enti tappu antunna

Sub query a kadu stored procedure, Triggers kuda vadochu

[gunturfriends]

not many would need to know about "Listagg" or Stuff functions , please read his question carefully before commenting. Its is easy to point but make fun after answering his question understanding what he need. just my thoughts