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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
2 |