with t as (select row_number()over(partition by asid,imagepath order by asid) as rnum from amz_image)
delete from t where rnum>1
Subscribe to:
Post Comments (Atom)
About Me
- Myblog
- Madhyamgram , WESTBENGAL, India
- I am Jagnnath from most famous City Kolkata..I just love Microsoft Technologies..working on some of them.Making people Network is my passion n so as coding..ASP.NET is my all time fav. topic.
1 comment:
Awesome. great query. It's really very helpful.
Post a Comment