Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2004
    Posts
    48

    Unanswered: extracting the duplicate values

    hi all

    i want to extract only the duplicate values from a table
    can any one know the sql syntax for that
    thnking u
    jag

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    select foo from yourtable
    group by foo having count(*) > 1
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2004
    Posts
    48

    Smile thnk u

    thnk u rudy thak u very much
    i got it!!!!!!!!!!!!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •