```
(select ID,EXTERNAL_TRANSACTION_ID,EXTERNAL_TRANSACTION_TYPE,ROW_NUMBER() OVER(PARTITION BY EXTERNAL_TRANSACTION_ID ORDER BY ID ) AS SEQNUM
from AC_POS_TRANSACTION_TRK aptt WHERE [RESULT] ='Success'
GROUP BY ID, EXTERNAL_TRANSACTION_ID,EXTERNAL_TRANSACTION_TYPE )

```

Hello,

On above query, I want to get rows of transaction id's which has seqnum=1 and seqnum=2

But if that transaction id has no second row (seqnum=2), I dont want to get any row for that transaction id.

Thanks!!

Something like this

![My Aim](https://i.stack.imgur.com/SdBSW.png)