Link to home
Start Free TrialLog in
Avatar of sqlcurious
sqlcuriousFlag for United States of America

asked on

need to delete one row if both rows are pretty similar

Customer_No       DateAdded                   status                      link                                             Row
3006471                        2014-04-29 10:39:35.037       good           http://www.google.com/url?sa=t                   1
3006471                        2014-04-29 10:39:35.050       bad           http://www.google.com/url?sa=t      2

Hi experts,
I need to delete row with status 'good' if  the time difference between both the rows is less than 1 minute and if the links are the same, pls suggest how to do
ASKER CERTIFIED SOLUTION
Avatar of John_Vidmar
John_Vidmar
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sqlcurious

ASKER

thanks