Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM payments
- WHERE
- (buy_currency_name='USD' OR buy_currency_name = 'EUR')
- AND
- (sell_currency_name='USD' or sell_currency_name='EUR')
- AND operation_rate IN (
- SELECT operation_rate FROM payments
- WHERE
- (buy_currency_name='USD' OR buy_currency_name = 'EUR')
- AND
- (sell_currency_name='USD' or sell_currency_name='EUR')
- GROUP BY operation_rate HAVING COUNT(operation_rate)>1)
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement