cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Akshaya
Frequent Visitor

Distinct Select Query in Oracle DB

Hi,

I need to know how we can apply a distinct query in Oracle table (Table 1) to get Table 2

 

Table 1

NameCol1Col2Col3

HOMS13M0524R0018
HOMS13M0108R0018
HOMS13M0536R0018
GINS13M0104R0018
GINS13M0106R0018
GINS13M0108R0018

 

Table 2

NameCol1

HOMS13
GINS13

 

Please someone let me know how we can do this

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,345)