Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    26

    Red face Unanswered: Extract doubles from a table!!!

    I need a query to extract all the double from a table.

    thanks

  2. #2
    Join Date
    Jan 2004
    Posts
    492

    Re: Extract doubles from a table!!!

    Originally posted by superj
    I need a query to extract all the double from a table.

    thanks
    I think this should work off the top of my head

    Code:
    select double_col, count(*)
    from your_table
    group by double_col
    having count(*) > 1

  3. #3
    Join Date
    Feb 2004
    Posts
    26

    thanks very much !!!!!!!

    thanks very much !!!!!!!

Posting Permissions

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