Results 1 to 2 of 2

Thread: Select

  1. 02-20-2002, 03:17 AM #1
    venki Guest

    Select

    HI,
    i want to find out any repeated values in one particular Field of the table..if so display those values..
    is there any solution for that.?
    Assist me
    Thanks in Advance
    Venki
    Reply With Quote Reply With Quote
  2. 02-21-2002, 11:33 AM #2
    Jim Steiner Guest

    Select (reply)

    Try:
    select count(*), yourfield
    from yourtable
    group by yourfield
    having count(*) > 1


    ------------
    venki at 2/20/2002 3:17:51 AM

    HI,
    i want to find out any repeated values in one particular Field of the table..if so display those values..
    is there any solution for that.?
    Assist me
    Thanks in Advance
    Venki
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules