Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- WITH groupTable (executionId, recordingProduct, ts, amount) AS (
- SELECT execution_id, rec_product_id, price_record_ts, COUNT(*) FROM PRECD001.ONLINE_RECORDING GROUP BY execution_id, rec_product_id, price_record_ts HAVING COUNT(*) > 1
- )
- SELECT * FROM PRECD001.ONLINE_RECORDING WHERE execution_id IN (
- SELECT executionId FROM groupTable
- ) AND rec_product_id IN (
- SELECT recordingProduct FROM groupTable
- ) AND price_record_ts IN (
- SELECT ts FROM groupTable
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement