DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: unique pair of columns

  1. #11
    Join Date
    Jun 2000
    Posts
    315
    Gandoif989 and srt:

    Thanks for the help! I tried to use distinct before the three columns. The query returned 1678 records.

    Thanks again!

  2. #12
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by lgaorcl
    Do you have any good SQL books to recommend to me?
    There are plenty around - but before that (excuse me for being rude) you will have to learn to express yourself simply, logically and precisely. If you can't write down in English (or Icelandic, Swahili, Urdu, Chineese or Malay) what you want, you'll never write SQL.

    Do the exercise now - write down on a piece of paper twenty typical rows from that_table, then write down the result you want, then write yourself instructions on how to get there. Then find at least three different ways of misunderstanding the instructions you gave yourself.

    If that sounds unkind - remember I'm a lot more forgiving than an SQL interpreter.

  3. #13
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by DaPi
    If that sounds unkind - remember I'm a lot more forgiving than an SQL interpreter.
    .. and your error messages are more verbose also.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

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


Click Here to Expand Forum to Full Width