Use a statement to delete duplicate records

Database Structure script:
If exists (select * from dbo. sysobjects where id = object_id (n' [dbo]. [TempA] ') and OBJECTPROPERTY (id, n'isusertable') = 1)
Drop table [dbo]. [TempA]
GO

Create table [dbo]. [TempA] (
[Id] [int] IDENTITY (1, 1) not null,
[PositionName] [varchar] (256) COLLATE Chinese_PRC_CI_AS NULL,
[EnglishPositionName] [varchar] (256) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

Alter table [dbo]. [TempA] ADD
CONSTRAINT [PK_TempA] PRIMARY KEY CLUSTERED
(
[Id]
) ON [PRIMARY]
GO

The TempA table has three fields with unique IDs and primary keys, which are automatically increased. PositionName and EnglishPositionName have repeated records, for example:
Id PositionName EnglishPositionName
20 Others
21 QC Engineer
22 other Others
.......
100 QC Engineer
Duplicate records such as "Others" and "Quality engineer" must be excluded.

SQL statement used:
Delete from TempA where id not in (
Select max (t1.id) from TempA t1 group
T1.PositionName, t1.EnglishPositionName)

Note:
(1) Remove the several fields used to judge duplicates and place them after the group by statement.
(2) max (t1.id) can also be changed to: min (t1.id)