How can I delete duplicate rows in SQL. Here is the current query. Select     EmployeeID,     Username,

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
Question

How can I delete duplicate rows in SQL. Here is the current query.

Select
    EmployeeID,
    Username,
    FirstName,
    LastName,
    RoleName,
    RoleDescription,
    Count(*) as '# of Duplicates'
From
    [dbo].[vw_MyAccessInfo]

Group by EmployeeID, Username, FirstName, LastName, RoleName,RoleDescription

Having Count(*) > 1

Delete from [dbo].[vw_MyAccessInfo]

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

This query is not correct as I'm still receiving this error. 

Msg 4145, Level 15, State 1, Line 15
An expression of non-boolean type specified in a context where a condition is expected, near ','.
Msg 102, Level 15, State 1, Line 17
Incorrect syntax near ')'.

Here is the query provided by you.

 

 

Solution
Bartleby Expert
SEE SOLUTION
Follow-up Question

The query provided is giving me errors (see below). Can you assist?

Msg 4104, Level 16, State 1, Line 5
The multi-part identifier "x2.id" could not be bound.

Completion time: 2022-08-09T11:32:00.7475729-05:00

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Multiple table
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
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