Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    9

    Unanswered: Unique set of combinations

    Hi guys

    I have a scenario where I have a table with many columns, where A and B are two of them. I would like to write a SQL query to find out the distinct combinations of A and B values in the table.

    If I needed distinct values of Column A, I would just say
    select distinct(A) from MYTABLE;

    but I am looking for distinct "combination" of A and B. How would I achieve this?

    Any help appreciated.

    Thanks
    -Chinna

  2. #2
    Join Date
    Sep 2003
    Posts
    9

    Figured out

    Guys,

    I figured that out.. Thanks anyways..

    -Chinna

Posting Permissions

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