Well I’m sure any SQL developer out there would have encountered a problem where the duplicate records in a table have to eliminated for some reasons. I recently encountered a similar situation where I had to remove the duplicate user name from a table with just one simple query . Here is how I did [...]
- Twitter Updates
-
Recent Comments
- Rolando Lopez on Don’t use Default attribute on CF9 ORM persistant object primary key instead use unSavedvalue
- Kum on Carton of Milk – 2$, Nokia N85 – 300$, the joy when the phone works after dropping the N85 in milk – priceless
- Veeraraghavan on Irony series
- Karthik on Irony series
- Kum on Windows 7 Vs Kubuntu 9.10 the fight continues..
-
Tags2008 2009 Adobe California cfml Codes Coldfusion comments election 2009 family guy Finance funny Funny Videos Google Grand Canyon Hindi India Jokes Lyrics Microsoft movie Movies Music News NRI Personal peter griffin photos Politics review sastha Software Srilanka tamil Tamil Movies Tamil Nadu Tamil Videos TECH Trip USA vacation Web World Yahoo youtube
-
-
Blogroll
-
Recent Posts
-
Google Analytics Stats5
Unique
VisitorsPowered By
-
Categories