Find Jobs
Hire Freelancers

SQL statement needed for an ORACLE db - I use SQL developer

£10-20 GBP

In Progress
Posted over 6 years ago

£10-20 GBP

Paid on delivery
I need a SQL statement written for an ORACLE db - I use SQL developer. Hi all, I need SQL to compare the below 2 sub queries and then only show values that are different in the 'latest' (subquery2) subquery. Both subqueries use the same table to SELECT FROM: **Subquery 1:** select tra_rac_accno, tra_cr from transactions join admin_periods on trunc(sysdate-7) between ape_start_date and ape_end_date and ape_admin_period_type = 'BAL' and ape_aye_aun_code = 'CANTERBURYW' and tra_date between ape_start_date and ape_end_Date where tra_trt_code = 'HBS' and tra_rac_accno not in ('2') order by tra_rac_accno ASC **Subquery 2:** select tra_rac_accno, tra_cr from transactions join admin_periods on trunc(sysdate) between ape_start_date and ape_end_date and ape_admin_period_type = 'BAL' and ape_aye_aun_code = 'CANTERBURYW' and tra_date between ape_start_date and ape_end_Date where tra_trt_code = 'HBS' and tra_rac_accno not in ('2') order by tra_rac_accno ASC Subquery 1 Output: **tra_rac_accno tra_cr** 318 66.7 323 97.67 328 107.26 336 96.95 340 80.14 Subquery 2 Output: **tra_rac_accno tra_cr** 318 69.5 323 97.67 328 107.26 336 96.95 340 50.20 I want to see the following output: **tra_rac_accno tra_cr** 318 69.5 340 50.20 I appreciate all who take time to read this post and also respond with assistance. THANK YOU!
Project ID: 15637945

About the project

2 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
A proposal has not yet been provided
£13 GBP in 1 day
0.0 (0 reviews)
0.0
0.0
2 freelancers are bidding on average £16 GBP for this job
User Avatar
I have checked detail your requirements and ready to start right now. I am available with Skype, Gtalk and phone. waiting for reply. Relevant Skills and Experience i have a experience in sql and oracle also Stay tuned, I'm still working on this proposal.
£18 GBP in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, UK, United Kingdom
0.0
0
Payment method verified
Member since Nov 14, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.