I am having an issue deleting duplicate rows in Sybase. I have a query
(DELETE x
FROM test x
WHERE (select count(*)
FROM test t
WHERE t.test1 = x.test1 AND
t.test2 = x.test2 AND
t.test_id <= x.test_id ) > 1)
that works correctly in SQL 7.0, but does not work in Sybase. Does anyone have a workaround as a delete query to do this for Sybase, without using a cursor?