morinia
asked on
Selecting only those records where there is only one row - Oraclw query
Experts,
I am reading a table in Oracle:
Select t1.CLAIM_NO
, t1.KICKOUT_CODE
, t1.cert_no
, t1.cost_center
, t1.arrv_date
From Table1;
I would like to select only those records where there is only one row where t1.claim_no, t1.cert_no are the same.
Does anyone know how/if this can be coded as a single query?
I am reading a table in Oracle:
Select t1.CLAIM_NO
, t1.KICKOUT_CODE
, t1.cert_no
, t1.cost_center
, t1.arrv_date
From Table1;
I would like to select only those records where there is only one row where t1.claim_no, t1.cert_no are the same.
Does anyone know how/if this can be coded as a single query?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.