How would I write this simple mysql equivalent in oracle?
select * from table group by column
It seems it does not accept star char when groupping, but it's really not practical to select columns one by one when there are 30+ columns in table.
select * from table
WHERE rowid in
(SELECT MIN(rowid)
FROM table
GROUP BY column);
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With