Database

create table [table] (
  id raw(32) default sys_guid(),
  ...,
  constraint pk_id primary key (id)
);

id_memberships AUTOINCREMENT PRIMARY KEY

CREATE TABLE [SAC_MEMBERSHIPS]
(
    [id_memberships] GUID NOT NULL PRIMARY KEY,
    ...

id_memberships GUID PRIMARY KEY DEFAULT GenGUID() NOT NULL

• Collect requirements
• Research tools and libraries
• Write code
• Test, diagnose problems, and correct errors.
• Repeat above until working

WITH CTE_fingerprint
AS (
	SELECT 
		employee_number
		,created_date
		,created_time
		,ROW_NUMBER() OVER (
		PARTITION BY
			employee_number
			,created_date
			,created_time
		ORDER BY 
			 employee_number
			,created_date
			,created_time
			) AS RowNumber
	FROM [fingerprint]
	)

DELETE
FROM CTE_fingerprint
WHERE RowNumber > 1;

SELECT *
FROM fingerprint t1 inner join fingerprint t2 on
t1.created_date=t2.created_date and t1.created_time = t2.created_time and t1.employee_number=t2.employee_number
Where t1.ID<t2.ID

DELETE 
FROM fingerprint
WHERE fingerprint.ID IN
(
    SELECT t1.ID
    FROM ... (see query above)
)