Need Assistance With Finding Duplicate Entries in a Table Combining Three Columns
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