I am writing a select query from a table TEST having three colums A,B,C in which i want to select distinct records on the basis of both the colums A and B.
If i give:
select distinct A,B,C from test;
it gives only the distinct records on the basis of column A. I tried this also:
select distinct A,B,C from test group by A,B;
but not working. Kindly suggest.