I am trying to figure out how to delete one instance of a redundant row from a table with a single column. For example, in table QueuedLoads I have one column, LoadNumber. The value in LoadNumber can (and will often be) the same as other rows in the table.
Table: QueuedLoads
LoadNumber
34389
34389
34389
4756
4756
1234
What I want to do is just delete ONE of the duplicate rows based on the user specifying which LoadNumber to delete. So I want to delete just one of the 34389 when I execute the query.
There is no preference as far as which row gets deleted, as it is only a single column table. I've seen a lot of examples of how to get rid of ALL of the redundant rows, but I need to keep all but one of the redundant rows.
Thanks for any help!
Table: QueuedLoads
LoadNumber
34389
34389
34389
4756
4756
1234
What I want to do is just delete ONE of the duplicate rows based on the user specifying which LoadNumber to delete. So I want to delete just one of the 34389 when I execute the query.
There is no preference as far as which row gets deleted, as it is only a single column table. I've seen a lot of examples of how to get rid of ALL of the redundant rows, but I need to keep all but one of the redundant rows.
Thanks for any help!