SQL question...

Results 1 to 2 of 2

Thread: SQL question...

  1. #1
    Join Date
    Dec 1969

    Default SQL question...

    How can retrieve a recordset that contains only unique values in it? I need to retrieve all values of a field in a database, butwithout duplicates. For example, to retrieve a all values from a field called &#039;FName&#039; but only returning one record of each value. If there are two &#039;Brad&#039; in the database it will return only one copy of it. Does that make any sense? Any help is appreciated.<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL question...

    sql="select distinct(FName) from table"

Posting Permissions

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