Question: Topic is Database Management. Please solve it on MSSQL 4 For below DEPARTMENT table write a SQL query query6.sal) so that repeated group names are
4 For below DEPARTMENT table write a SQL query query6.sal) so that repeated group names are shown with quotation symbol like in above desired output DEPARTMENT Desired output ID GroupName D GroupName 1 Research and Development 1 Research and Development 2 Research and Development 2 3 Sales and Marketing 3 Sales and Marketing 4 Sales and Marketing 5 Inventory Management 5 Inventory Management 6 Research and Development 6 Research and Development 7 Maracturing 7 Manufacturing 8 Manufacturing 8 Executive General and Administration Boecutive General and Administration 10 Executive General and Administration 10 11 Executive General and Administration 11 12 Quality Assurance 12 Quality Assurance 13 Quality Assurance 13 14 Executive General and Administration 14 Executive General and Administration 15 inventory Management 15 Inventory Management 15 Executive General and Administration 16 Executive General and Administration 9 9
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
