Click here to Skip to main content
11,707,470 members (78,154 online)

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

Database
General
Posted: 2 Sep 2011   Updated: 2 Sep 2011   Views: 8,830   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
Web02 | 2.8.150819.1 | Last Updated 31 Aug 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid