将两列以上的数据组合成一个临时列。 [英] combinig more then two columns data into one temporary column.

问题描述

如何将两列以上的数据合并到一个临时列中



实际上我加入了两个看起来像这样的表

< pre lang =text> ------------------------------------------- ------------------------------
First_Name Email_Id City State industry_type
nitish [e-mail] vijayawada AP IT
TEJA [e-mail] vijayawada AP IT
MANI [e-mail] vijayawada AP IT

//使用以下查询我得表这个表

 选择 r.First_Name，r.Email_Id，r.City，r.State，e.industry_type 
 来自注册 as  r 
  inner   join  Experience_Detail  as  e 
 上的<= span> > r.Login_Id = e.Login_Id 

现在我想要的结果应该是喜欢这个以下表格

 ------------------------------ ----------------------------------------------- 
 
 First_Name Email_Id City State industry_type FullDetails 
 nitish [e-mail] vijayawada AP IT [by-nitish，email_id，
 TEJA [e-mail] vijayawada AP IT vijayawada，AP，IT] 
 MANI [e-mail] vijayawada AP IT 

[edit]已添加代码块 - OriginalGriff [/ edit]

解决方案

假设它们是（例如）字符串，请尝试：

SELECT myColumn1 + myColumn2 AS DisplayName FROM myTable





我修改了问题先生。



答案仍然是相同的 - 你只需要扩展一下：

 选择 r.First_Name，r.Email_Id，r.City，r.State，e.industry_type，
 '  [by  - ' + r.First_Name + '  ，' + r.Email_Id + '  ，' + r.City + 
 ' ，' + r.State + ' ，' + e.industry_type  AS  FullDetails 
 来自注册 as  r 
 内部 加入 Experience_Detail  as  e 
  on  r.Login_Id = e.Login_Id 

您好，



尝试这个

 选择 r.First_Name，r.Email_Id，r.City，r .State，e.industry_type，
 r.First_Name + ' ，' + r.Email_Id + < span class =code-string>' ，' + r.City + ' < span class =code-string>，' + r.State + ' ，' + e.industry_type  AS  FULLDETAILS 
 来自注册 as  r 
  inner   join  Experience_Detail  as  e 
  on  r.Login_Id = e.Login_Id 

注意：通过使用Concatinate获取此结果的列，如果所有列的数据类型不同，则必须使用convertion。

how can i combine more then two columns data into one temporary column

actually i joined two tables that looks like this

-------------------------------------------------------------------------
First_Name  Email_Id              City        State        industry_type  
nitish      [e-mail]    vijayawada    AP            IT
TEJA        [e-mail]    vijayawada    AP            IT
MANI        [e-mail]    vijayawada    AP            IT

//BY USING BELOW QUERY I GOT THIS TABLE

select r.First_Name,r.Email_Id,r.City,r.State,e.industry_type
from Registration as r
inner join Experience_Detail as e
on r.Login_Id=e.Login_Id

NOW I WANT THE RESULT SHOULD BE LIKE THIS BELOW TABLE

-----------------------------------------------------------------------------

First_Name  Email_Id              City        State industry_type  FullDetails  
nitish      [e-mail]    vijayawada    AP     IT       [by-nitish,email_id,
TEJA        [e-mail]    vijayawada    AP     IT        vijayawada,AP,IT]  
MANI        [e-mail]    vijayawada    AP     IT

[edit]Code block added - OriginalGriff[/edit]

解决方案

Assuming that they are (for example) strings, try:
SELECT myColumn1 + myColumn2 AS DisplayName FROM myTable


"I Modified the question sir."

The answer is still the same - you just have to expand it a bit:

select r.First_Name,r.Email_Id,r.City,r.State,e.industry_type,
       '[by-' + r.First_Name + ',' + r.Email_Id + ',' + r.City +
              ',' + r.State + ',' + e.industry_type AS FullDetails
from Registration as r
inner join Experience_Detail as e
on r.Login_Id=e.Login_Id

Hi,

try this

select r.First_Name,r.Email_Id,r.City,r.State,e.industry_type,
r.First_Name+','+r.Email_Id+','+r.City+','+r.State+','+e.industry_type AS FULLDETAILS
from Registration as r
inner join Experience_Detail as e
on r.Login_Id=e.Login_Id

NOTE: By using Concatinate the columns you fetch this result, if the datatype of all columns is different then you must use convertion.

这篇关于将两列以上的数据组合成一个临时列。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！