Here we will learn on how can we combine two or more columns in a SQL query.
select UHID,ServiceName,EMR_id,is_sample_collected + ' ' + is_billing_done + ' ' + collected_sample_name as YourDesiredColumn, collected_by_User
from HIS_Service_Order_Sample_Detail
Best Regards
Amit Vaid
No comments:
Post a Comment