SQL & PL/SQL

Hi All,

I have 2 columns which returns records like this Say Column A and Column B.

A B
--------
1 1
1 1
2 2
2 2
3, 3

I need only distinct records from these columns. So i executed DISTINCT Clause in my query and it returned unique records. Issue is I need to execute a query like this i.e compulsorily use ROWID in my select list.

i.e SELECT DISTINCT ROWID A, B from TEST;

But this query we will give duplicated records only when we give rowid, how to achieve a output like this using rowid in the column select list of my query.


A B
--------
1 1
2 2
3, 3

Please Help.

Thanks in advance.