Delete records of a query

Question

I want to be able to delete "all" the records from the results of the query below. So if I find two John Smiths with same date of birth, delete them both.

Select LastName, FirstName, DateOfBirth, Count () As Duplicates From PatientDemographics2 Group by FirstName, LastName, DateOfBirth Having count () >1 Order by LastName, FirstName Asc

Possible duplicate of [Remove duplicate rows in MySQL](https://stackoverflow.com/questions/3311903/remove-duplicate-rows-in-mysql) — Nithin Kumar Biliya, Sep 22 '19 at 03:49

score 0 · Answer 1 · edited Sep 22 '19 at 01:32

0

To remove one or more rows in a table: First of all you will have to specify the table name where you want to remove data in the DELETE FROM clause. Fuethermore if you put the conditions remark "WHERE" clause it specifies which rows to remove. If you omit the WHERE clause, the statement will remove all rows in the table.

edited Sep 22 '19 at 01:32

Jim Hayes

2,126
1
15
21

answered Sep 21 '19 at 21:14

leozory

1
1

1

This answer could be improved by providing an SQL example, rather than just describing what it would look like. – Jim Hayes Sep 22 '19 at 01:32

Delete records of a query

1 Answers1