Advertisement
Guest User

Untitled

a guest
Jan 14th, 2018
197
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT * FROM payments
  2.         WHERE
  3.           (buy_currency_name='USD' OR buy_currency_name = 'EUR')
  4.           AND
  5.           (sell_currency_name='USD' or sell_currency_name='EUR')
  6.           AND operation_rate IN (
  7.                 SELECT operation_rate FROM payments
  8.                         WHERE
  9.                             (buy_currency_name='USD' OR buy_currency_name = 'EUR')
  10.                             AND
  11.                             (sell_currency_name='USD' or sell_currency_name='EUR')
  12.           GROUP BY operation_rate HAVING COUNT(operation_rate)>1)
  13.         ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement