Jump to content

SQL Server data help


sqlhelp

Recommended Posts

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

Link to comment
Share on other sites

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..

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...