Click here to Skip to main content

Articles by Ron sikander (Tip/Trick: 1)

Tip/Trick: 1

RSS Feed
No articles have been posted.
No blogs have been submitted.

Average tips rating: 0.00

Posted: 2 Sep 2011   Updated: 2 Sep 2011   Views: 8,160   Rating: 0.0 / 5    Votes: 0   Popularity: 0.0
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Find out the number of duplicates in the table:select count(*), VISTX_ST_FIPS,VISTX_CTY_FIPS,VISTX_TC from TR00.NV_STARTER_INDEXgroup by VISTX_ST_FIPS,VISTX_CTY_FIPS,VISTX_TC having count(*)>1--- Delele them using following statementDELETEFROM TR00.NV_STARTER_INDEXWHERE...
No reference articles have been posted.

Ron sikander

United States United States
No Biography provided

Advertise | Privacy | Mobile
Web04 | 2.8.150414.1 | Last Updated 21 Apr 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid