-3

I created a table but don't know how to show two column data in single column can some help me

Adarsh Bhardwaj
  • 88
  • 7
  • 1
    provide sample data and your desired output in table fromat – Fahmi Oct 20 '20 at 05:53
  • table uploaded check https://i.stack.imgur.com/YbpNE.png Here is the table i want to see emp_name and emp_uid in a single column only – Adarsh Bhardwaj Oct 20 '20 at 05:58
  • Duplicate of https://stackoverflow.com/q/1619259/1509264 or https://stackoverflow.com/q/20268273/1509264 – MT0 Oct 20 '20 at 08:56

1 Answers1

1

Use concat() function

select concat(emp_id, emp_name) as derive_col 
from yourtablename
Fahmi
  • 37,315
  • 5
  • 22
  • 31