SQL returning full objects (*) from distincted columns

Question

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! :)

Your question is not clear. Please update it to let us know what you want. — Tim Biegeleisen, Jun 09 '15 at 06:53
You can use "Group By mt.column1, mt.column2, mt.column3" . This may help if I am understanding your problem correctly. — Nikhil Batra, Jun 09 '15 at 06:53
@NikhilBatra, does Oracle really cheat when it comes to GROUP BY? (Like some other dbms products do...) — jarlh, Jun 09 '15 at 06:55
As far as I know oracle is the most honest and sincere DBMS following all the rules, so I can't call it a cheater :P — Nikhil Batra, Jun 09 '15 at 06:57
Are you looking to exclude rows which have `NULL` values in any of the table's columns? — Radu Gheorghiu, Jun 09 '15 at 07:09

score 1 · Accepted Answer · answered Jun 09 '15 at 07:06

1

I think you are looking for a query like this:

SELECT *
FROM (
    SELECT 
        *, ROW_NUMBER() OVER (PARTITION BY mt.column1, mt.column2, mt.column3 ORDER BY mt.column1, mt.column2, mt.column3) As Seq
    FROM 
        MyTable mt) AS DT
WHERE
    Seq = 1;

answered Jun 09 '15 at 07:06

shA.t

16,580
5
54
111

1

[I think not](http://stackoverflow.com/q/11206498/4519059) and you need to do it in other way ;). – shA.t Jun 09 '15 at 07:36

SQL returning full objects (*) from distincted columns

1 Answers1