Hi,
I need to know how we can apply a distinct query in Oracle table (Table 1) to get Table 2
Table 1
NameCol1Col2Col3
HOM | S13 | M0524 | R0018 |
HOM | S13 | M0108 | R0018 |
HOM | S13 | M0536 | R0018 |
GIN | S13 | M0104 | R0018 |
GIN | S13 | M0106 | R0018 |
GIN | S13 | M0108 | R0018 |
Table 2
NameCol1
HOM | S13 |
GIN | S13 |
Please someone let me know how we can do this