Please update your Flash Player to view content.
Close



Send Gifts Send Gifts
Daily Stars Daily Stars

Online Users

0 users and 355 guests online

Monthly Winners

  • images/stories/gifts/HariHara.jpg
  • images/stories/gifts/Hemalatha.jpg
  • images/stories/gifts/Mahesh.jpg
  • images/stories/gifts/MaheshGuptha.jpg
  • images/stories/gifts/Naresh.jpg
  • images/stories/gifts/Nithin.jpg
  • images/stories/gifts/Sudhir.jpg
  • images/stories/gifts/Usha.jpg
  • images/stories/gifts/gajavelly.jpg

Points

Top Earners

Daily Toppers

InboxCompose

Utilities

Tech Games

Last Points Earned

Tutorials

Tech Shatabdhi Radio


Techies Discussions

  • Hidden Facts-Secrets From Microsoft - by - smallnithin
  • History Of The Day - by - smallnithin
  • Reg:.Net Developer@Hyderabad - by - cgajavelly
  • History Of The Day - by - smallnithin
  • CRYSTAL REPORTS DEVELOPER Opportunity in VIZAG - by - cgajavelly
  • Requirement for Software Engineer-.Net,i3 Software - by - cgajavelly
  • Władysław Szpilman - The Great Survivor - by - smallnithin
  • Openings for .net Developer - by - naru
  • Walkin for C & Java - by - naru
  • Dot Net Team Lead - by - naru
  • Openings for .net Developer - by - naru
  • PHP, FLEX, Android Developer Required with 1+ year - by - naru
  • WEB DESIGNING Training in Noida/Delhi/NCR - by - naru
  • Graphic/Web Designer (exp 06 month - 01 yrs) - by - naru
  • Required PHP MySQL Developers For Noida - by - naru
  • Software Developer [6mnths to 2 yrs] male r female - by - naru
  • Vacancy for PHP Developer - by - naru

    • Latest Comments

    Techies Adda

    Latest Updates

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Certificates and points sent to August Winners.

    Interview Experiences module Added

    Win A Weekly Video Library Contest Started

    Weekly toppers, star of the day modules added.

    Added 100% compatibility to all mobile phones

    Upcoming Events

    No events found.
    Sign in with Facebook

    Video Comments

    Redeem Points


    Most Referral Users

    Gowridevi
    21
    Nithin Mohan
    12
    BangaruBabu Pureti
    8
    DurgaPrasad
    5
    somanatha reddy.g
    4
    100% Non Commercial
    Lets Help Lets Grow

    Circles

    All Friends
    Welcome, Guest
    Please Login or Register.    Lost Password?
    Hyderabad Techies Forum
    Hyderabad Techies Forum
    SQL SERVER

    Remove Duplicate Records SQL Query
    (1 viewing) (1) Guest
    Go to bottomPage: 1
    TOPIC: Remove Duplicate Records SQL Query
    #2055
    Remove Duplicate Records SQL Query 1 Year, 11 Months ago Karma: 2
    CREATE
    TABLE #phonebook (
    [phonenumber] [varchar] (30),
    [firstname] [varchar] (30),
    [lastname] [varchar] (30),
    [company] [varchar] (100)
    )
    INSERT
    #phonebook SELECT '902','syed','iqbal','sm soft'
    INSERT #phonebook SELECT '905','john','ksjl89','company llc'
    INSERT #phonebook SELECT '909','joe','average','united'
    -- Duplicate insert 1
    INSERT
    #phonebook SELECT '902','syed','iqbal','sm soft'
    INSERT #phonebook SELECT '905','john','ksjl89','company llc'
    INSERT #phonebook SELECT '909','joe','average','united'
    -- Duplicate insert 2
    INSERT
    #phonebook SELECT '902','syed','iqbal','sm soft'
    INSERT #phonebook SELECT '905','john','ksjl89','company llc'
    INSERT #phonebook SELECT '909','joe','average','united'
    --Show Duplicate Phonenumbers in Phonebook
    SELECT
    phonenumber, COUNT(*) FROM #phonebook
    GROUP BY phonenumber HAVING COUNT(*) > 1
    ORDER BY COUNT(*) DESC
    SET ROWCOUNT 1
    SELECT
    @@rowcount
    WHILE @@rowcount > 0
    DELETE pb FROM #phonebook as pb
    INNER JOIN
    (SELECT phonenumber
    FROM #phonebook
    GROUP BY phonenumber HAVING count(*) > 1)
    AS c ON c.phonenumber = pb.phonenumber

    SET ROWCOUNT 0

    SELECT * FROM #phonebook
    DROP TABLE #phonebook
    meetdine (User)
    Platinum Boarder
    Posts: 801
    graph
    Points: 162420
    graphgraph
    User Offline Click here to see the profile of this user
    Last Edit: 2010/03/09 05:59 By meetdine.
    The administrator has disabled public write access.
    		 
    #2256
    Re: Remove Duplicate Records SQL Query 1 Year, 11 Months ago Karma: 0
    thanx
    kumarsudu (User)
    Senior Boarder
    Posts: 79
    graphgraph
    Points: 55022
    graphgraph
    User Offline Click here to see the profile of this user
    The administrator has disabled public write access.
    		 
    Go to topPage: 1
    Hyderabad Techies Forum
    Hyderabad Techies Forum
    SQL SERVER
    Moderators: chandu, harihara.muvvala, usham
    Powered by Kunenaget the latest posts directly to your desktop