Find and remove duplicate entries in SQL Server Database

I have a sql server database with multiple duplicate entries and at times only some of the fields are duplicates. The fields are Name, Job and Rate. You can use only SQL to do these jobs, or use asp as well and I will implement it on a page. NO OTHER LANGUAGES ARE ACCEPTABLE!!!

I need three separate queries/scripts that find the following:

Find all of the instances when Name and Job are the same, but rate is different. Don't need to know how many of each, just what the name and job are and the different rates. The result should be every name,job and rate where there is another entry with the same name and job, but different rate.

Tell me how many identical entries there are for the same Name, Job and Rate.

Code that will delete all but one of the entries for each of the results from job 2.

## Deliverables

1) All deliverables will be considered "work made for hire" under U.S. Copyright law. Employer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the employer on the site per the worker's Worker Legal Agreement).

2) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

3) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Employer's environment--Deliverables must be installed by the Worker in ready-to-run condition in the Employer's environment.

b) For all others including desktop software or software the employer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this project.

The result of job one would look like this

John D, painting, 25

John D, painting, 30

John D, painting, 40

Fred H, lumber, 15

Fred H, lumber, 20

Job 2

John H, painting, 25, 3 (this last number is how many entries)

## Platform

SQL Server, ASP on windows machine.

MySQL 脚本安装 shell脚本 软件构架 SQL

项目ID： #3696796

关于项目