Hi all,
I'm using SQL Server 7.0. I have two identical entries in my SQL table. Does anyone out there have an sql query, or know of a way to delete one of two identical entries. To display only one of the two is OK when using the DISTINCT keyword, but I'd like to remove the second one. Any comments will be appreciated. Have a good day.
I'm using SQL Server 7.0. I have two identical entries in my SQL table. Does anyone out there have an sql query, or know of a way to delete one of two identical entries. To display only one of the two is OK when using the DISTINCT keyword, but I'd like to remove the second one. Any comments will be appreciated. Have a good day.