SQL Language (MOSC)

MOSC Banner

Need Assistance With Finding Duplicate Entries in a Table Combining Three Columns

edited Oct 25, 2010 9:09PM in SQL Language (MOSC) 12 commentsAnswered ✓
 Hi Folks

i have a table of data that may have duplicate entries combining first three columns within the same table
can someone tell me how i would extract the duplicates if there are any from that table ?

example table:
table 1

example columns:

parentid,
ownerid,
name,
indate,
outdate,
dataid

want to select on first first three columns combined together:

parentid||ownerid||name

Any Assistance is Appreciated

Jim

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center