Advertisement
Guest User

Untitled

a guest
Nov 13th, 2019
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.46 KB | None | 0 0
  1. WITH groupTable (executionId, recordingProduct, ts, amount) AS (
  2.     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
  3. )
  4.  
  5. SELECT * FROM PRECD001.ONLINE_RECORDING WHERE execution_id IN (
  6.     SELECT executionId FROM groupTable
  7. ) AND rec_product_id IN (
  8.     SELECT recordingProduct FROM groupTable
  9. ) AND price_record_ts IN (
  10.     SELECT ts FROM groupTable
  11. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement