Click here to Skip to main content
13,248,766 members (58,584 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: 11,460   Rating: 0.00/5    Votes:    Popularity: 0.00
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
This member doesn't quite have enough reputation to be able to display their biography and homepage.


Advertise | Privacy |
Web04 | 2.8.171114.1 | Last Updated 18 Nov 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid