100% Results Messages InstructorID Last Name First Name Status Department Chairman Hire Date Annual Salary DepartmentID 72222222 17 17 Benedict Susan P 0 2024-04-22 34000.00 9 18 18 Adams NULL F 1 2024-04-22 66000.00 9 19 19 Benedict Susan P 0 2024-04-22 34000.00 9 20 20 Adams NULL LL 1 2024-04-22 66000.00 9 21 21 Benedict Susan P 0 2024-04-22 34000.00 9 23 24 222 Adams NULL LL F 1 2024-04-22 66000.00 9 23 Benedict Susan 24 Adams NULL PE P 0 2024-04-22 34000.00 9 F 1 2024-04-22 66000.00 9 656

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)
1st Edition
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Chapter11: Building Solutions: Database, System, And Application Development Tools
Section: Chapter Questions
Problem 23CT
icon
Related questions
Question
100%

Having problems where my inserted rows duplicate every time I run my SQL query. How do I delete them?

100%
Results
Messages
InstructorID Last Name
First Name
Status
Department Chairman Hire Date
Annual Salary
DepartmentID
72222222
17
17
Benedict
Susan
P
0
2024-04-22
34000.00
9
18
18
Adams
NULL
F
1
2024-04-22 66000.00
9
19
19
Benedict
Susan
P
0
2024-04-22 34000.00
9
20
20
Adams
NULL
LL
1
2024-04-22 66000.00
9
21
21
Benedict
Susan
P
0
2024-04-22 34000.00
9
23
24
222
Adams
NULL
LL
F
1
2024-04-22 66000.00
9
23
Benedict
Susan
24
Adams
NULL
PE
P
0
2024-04-22 34000.00
9
F
1
2024-04-22 66000.00 9
656
Transcribed Image Text:100% Results Messages InstructorID Last Name First Name Status Department Chairman Hire Date Annual Salary DepartmentID 72222222 17 17 Benedict Susan P 0 2024-04-22 34000.00 9 18 18 Adams NULL F 1 2024-04-22 66000.00 9 19 19 Benedict Susan P 0 2024-04-22 34000.00 9 20 20 Adams NULL LL 1 2024-04-22 66000.00 9 21 21 Benedict Susan P 0 2024-04-22 34000.00 9 23 24 222 Adams NULL LL F 1 2024-04-22 66000.00 9 23 Benedict Susan 24 Adams NULL PE P 0 2024-04-22 34000.00 9 F 1 2024-04-22 66000.00 9 656
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Enhanced Discovering Computers 2017 (Shelly Cashm…
Enhanced Discovering Computers 2017 (Shelly Cashm…
Computer Science
ISBN:
9781305657458
Author:
Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:
Cengage Learning
Programming Logic & Design Comprehensive
Programming Logic & Design Comprehensive
Computer Science
ISBN:
9781337669405
Author:
FARRELL
Publisher:
Cengage
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning