如何连接两个字段？

SELECT RoadGuid,to_char(RebuildDate,'yyyymmdd') FROM civicism.tbCityRation
该语句可以执行
SELECT RoadGuid+to_char(RebuildDate,'yyyymmdd') FROM civicism.tbCityRation
不能执行现希望将两个字段合成一个字段，作为列名。望各位达人教我

解决方案 »

  1.   

    SELECT RoadGuid || to_char(RebuildDate,'yyyymmdd') FROM civicism.tbCityRation
      

  2.   

    SELECT RoadGuid || to_char(RebuildDate,'yyyymmdd') t1 FROM civicism.tbCityRation
      

  3.   

    SELECT RoadGuid || ' '|| to_char(RebuildDate,'yyyymmdd') t1 FROM civicism.tbCityRation
      

  4.   

    SELECT RoadGuid || ' '|| to_char(RebuildDate,'yyyymmdd') t1 FROM civicism.tbCityRation
      

  5.   

    SELECT RoadGuid || ' '|| to_char(RebuildDate,'yyyymmdd')  FROM civicism.tbCityRation