if you have an unique id in the table, then i would go for something like this:
SELECT A,B,C,D FROM table WHERE id IN (SELECT DISTINCT A,B,D)
The problem is that you would always get the first value of C, not the fristfirst one with an value.
Find centralized, trusted content and collaborate around the technologies you use most.
Learn more about CollectivesStack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack Internalif you have an unique id in the table, then i would go for something like this:
SELECT A,B,C,D FROM table WHERE id IN (SELECT DISTINCT A,B,D)
The problem is that you would always get the first value of C, not the fristfirst one with an value.
if you have an unique id in the table, then i would go for something like this:
SELECT A,B,C,D FROM table WHERE id IN (SELECT DISTINCT A,B,D)
The problem is that you would always get the first value of C, not the frist one with an value.
if you have an unique id in the table, then i would go for something like this:
SELECT A,B,C,D FROM table WHERE id IN (SELECT DISTINCT A,B,D)
The problem is that you would always get the first value of C, not the first one with an value.
