I am looking for a solution concerning SQL Query for Oracle DB what returns DISTINCT full objects from many columns e.g:
SELECT DISTINCT mt.column1, mt.column2, mt.column3 FROM MyTable mt;
But I need full objects like SELECT * FROM MyTable
Is there any way to obtain such effect using usual SQL statements?
Thanks in advance! :)
I think you are looking for a query like this: