No More Spool Space Teradata Query Solution
Kedar
Have you ever come across a situation called NO MORE SPOOL SPACE? My friend does and hence I studied a bit about Teradata. The error: “NO MORE SPOOL SPACE”. Correct, the problem…
Browsing Tag
query
2 posts
Oracle query-eliminate duplicate but one using rowid
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…
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;