SQL duplicate table?
I accidentally executed an employee table twice. Now it displays a table with Employees 1-4 and then Employees 1-4 again below. How do I remove the last four employees so they aren't listed twice? The names in the image are purely random, as I'm just practicing with them.
You can remove the entries on the ID as well as the Staff_Id orient. The last column probably tells you if an entry in value corresponds to another one. The ID can show you if you have the first occurrence in front of you or not.
Following, I assume that your table with employees name.
It can be that it works if you make a right click on the table name and then click on “Edit Top 200 Lines”. Then you can mark the lines and press [entf].
If no one is twice in the table, you should define the Column Employee_Id as a primary key for the table. So open the table as a design, click the Employee_Id column and click on the golden key in the toolbar above. Then you can no longer insert duplicate records into the table.