For below DEPARTMENT table write a SQL query  so that repeated group names are shown with quotation symbol like in above desired output   For understanding logic, can you give simple example in Microsoft SQL Server Management Studio 18. Thank you.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question

For below DEPARTMENT table write a SQL query  so that repeated group names are shown with quotation symbol like in above desired output

 

For understanding logic, can you give simple example in Microsoft SQL Server Management Studio 18. Thank you.

DEPARTMENT
Desired output
ID
GroupName
ID
Group Name
1
Research and Development
1
Research and Development
2
Research and Development
3
Sales and Marketing
3
Sales and Marcetng
4
Sales and Marketing
4
5
hventory Management
Inventory Management
Rescarch and Dovelopment
6
Research and Development
7
Marufacturing
Manufacturing
8
Marufactuing
Executive General and Administration
Executive Generd and Adriristration
10
Executive General and Administration
10
11
Executive General and Administration
11
12
Quality Asourance
12 Qualty Assurance
13 Quality Assurance
13
14
Executive General and Administration
14
Executive General and Adminietration
15
hventory Management
15
Inventory Management
16
Executive General and Administration
16
Executive Gereral and Administration
Transcribed Image Text:DEPARTMENT Desired output ID GroupName ID Group Name 1 Research and Development 1 Research and Development 2 Research and Development 3 Sales and Marketing 3 Sales and Marcetng 4 Sales and Marketing 4 5 hventory Management Inventory Management Rescarch and Dovelopment 6 Research and Development 7 Marufacturing Manufacturing 8 Marufactuing Executive General and Administration Executive Generd and Adriristration 10 Executive General and Administration 10 11 Executive General and Administration 11 12 Quality Asourance 12 Qualty Assurance 13 Quality Assurance 13 14 Executive General and Administration 14 Executive General and Adminietration 15 hventory Management 15 Inventory Management 16 Executive General and Administration 16 Executive Gereral and Administration
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education