How to select distinct multi-column values in Oracle SQL?

Question

I am trying to get distinct values with multi column select.

Sample table:

CREATE TABLE DUP_VALUES (ID NUMBER, NAME VARCHAR2(64));

 INSERT INTO DUP_VALUES values (1, 'TEST1');
 INSERT INTO DUP_VALUES values (2, 'TEST1');
 INSERT INTO DUP_VALUES values (3, 'TEST2');
 INSERT INTO DUP_VALUES values (4, 'TEST2');
 INSERT INTO DUP_VALUES values (5, 'TEST1');
 INSERT INTO DUP_VALUES values (6, 'TEST1');
 INSERT INTO DUP_VALUES values (7, 'TEST1');

I want to get

ID NAME
1  TEST1
3  TEST2

I tried with SELECT DISTINCT ID, NAME FROM DUP_VALUES

But, I got all values, because ID is unique.

Gordon Linoff · Accepted Answer · 2021-06-26 11:04:00Z

3

Use aggregation:

select min(id) as id, name
from dup_values
group by name;

answered Jun 26, 2021 at 11:04

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to select distinct multi-column values in Oracle SQL?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related