Advertisement
Guest User

Untitled

a guest
Dec 8th, 2016
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. SELECT Cust_ID, total, Commercial.COMPANY_NAME, Commercial.VAT_Number FROM
  2. (
  3. SELECT Customer_ID AS Cust_ID, SUM(Payment_Amount) total FROM
  4. (
  5. SELECT * FROM Order_Table, Pay_Link WHERE Order_Table.Order_ID = Pay_Link.Order_ID
  6. )
  7. GROUP BY Customer_ID
  8. ORDER BY total DESC
  9. ), Commercial
  10. INNER JOIN Customer
  11. ON Customer.Customer_ID = Commercial.Customer_ID
  12. WHERE ROWNUM <= (SELECT COUNT (*) FROM Commercial) / 4 AND cust_id = Commercial.Customer_ID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement