rtpmamen4d

1 Answer. agust d haegeum lyrics Sorted by: 2 You can select transactions with same payment id but different payment type by next query: SELECT payment_Id FROM payments GROUP BY payment_Id HAVING COUNT (DISTINCT paymentType) 1; So your final query may be next: SELECT transID, transType, createdDate, paymentAmount_rtp, paymentAmount_tenders, DesiredResult