Your technology certification is waiting. Enroll in Cloud Class ®
Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.
SELECT FieldName, COUNT(*) TotalCount
GROUP BY FieldName
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
Open in new window
SELECT ROW_NUMBER () OVER ( PARTITION BY YourField ORDER BY YourField) AS RNUM
DELETE FROM SimpleDLTE WHERE RNUM > 1
/* Your Details without Duplicates */
SELECT * FROM [YourDB].[dbo].[YourTable]
DELETE FROM YourTableOwner.YourTabel WHERE rowid not in (SELECT MIN(rowid) FROM YourTableOwner.YourTabel GROUP BY YourField)
delete from cal_obj where rowid in (
select rowid from (
row_number () over (partition by obj_name order by rowid) as rid
from cal_obj) where rid <> 1);
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Please enter a first name
Please enter a last name
Must be at least 4 characters long.
Join and Comment
From novice to tech pro — start learning today.
Premium members can enroll in this course at no extra cost.