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
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,148)