Oracle query-eliminate duplicate but one using rowidKedarFebruary 8, 2010 Yesterday a friend came across an oracle query problem: Consider below table: cid cname…. cdata 1 x xxxx 1 x xxxx .. 2 xzzz fjnd 3 a evddd Now the… View Post
Kedar
One response to “Oracle query-eliminate duplicate but one using rowid”
1. try defining a primary key.
or use something like:
select * from(
select first_value(cname) over( partition by cid order by cname) cname, cid from tablename) group by cname,cid;