Results 1 to 3 of 3

Thread: Select Dis

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Select Dis

    Waht is the diffrence between SELECT DISTINCT and [COLOR=Green] SELECT DISTINCTROWSELECT DISTINCT

    Thanks

  2. #2
    Join Date
    Oct 2003
    Location
    US
    Posts
    343

    Re: Select Dis

    SELECT DISTINCT :Omits records that contain duplicate data in the selected fields. To be included in the results of the query, the values for each field listed in the SELECT statement must be unique

    SELECT DISTINCTROW : Omits data based on entire duplicate records, not just duplicate fields


    Originally posted by hammbakka
    Waht is the diffrence between SELECT DISTINCT and [COLOR=Green] SELECT DISTINCTROWSELECT DISTINCT

    Thanks

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thank you Khan, that's fine

Posting Permissions

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