Hi, I am new to SQL Server querying and I have a table called "mapping_tbl" which looks like the below: it has 3 columns Order_No, Name, & Generic_Name.
I have installed Management Studio to query the database and can see the table by writing:
select * from [mapping_tbl]
Order_No | Name | Generic_Name
1 | Accessories | Sub_Cat1
2 | Appliances | Sub_Cat2
What query do I need to write in order to present the data of Generic_Name into separate columns and have a 1 row that shows Name?
Here is what the outcome should look like: