Oracle query-eliminate duplicate but one using rowid
Kedar
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…
Browsing Tag
elliminatae duplicate in oracle
1 post
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;