SQL -Grab unique column combination from table
In Oracle, I have a table called "MyTable". This table has columns 'A' and 'B'. I want to find every unique combination of 'A' and 'B'. How would I do this? I'd prefer to do this in SQL rather than PL/SQL.
Example:
Column A | Column B
开发者_StackOverflow中文版Dog Cat
Cat Dog
Horse Cat
Dog Cat
A unique combination above should return 3 rows.
Thank You
select distinct columnA, columnB from table
or
select columnA, columnB from table
group by columnA, columnB
Do it like this:
Select A, B
From MyTable
Group by A, B
精彩评论