skip the group
-- Update: as correctly pointed the SQL won't work. Updated the sql
Hello,
i spent sometime trying to get this to work, but hit the block. Any ideas are welcome.
i have a query that returns several groups of records. Then it joins the result to a lookup table (by PK) and, as the final result of the query, returns only the records from the given group where not a single record exists in the lookup table.
smth like this:
select * from (
select b.id, b.version_num,
sum(NVL(b.id,0)) over(partition by b.id, b.version_num) GRP
i spent sometime trying to get this to work, but hit the block. Any ideas are welcome.
i have a query that returns several groups of records. Then it joins the result to a lookup table (by PK) and, as the final result of the query, returns only the records from the given group where not a single record exists in the lookup table.
smth like this:
select * from (
select b.id, b.version_num,
sum(NVL(b.id,0)) over(partition by b.id, b.version_num) GRP
0