Find Jobs
Hire Freelancers

Postgres Join help required

$8-15 USD / hour

Closed
Posted over 3 years ago

$8-15 USD / hour

I have one table of Dates I have created for the last 90 days. I want to join my second table, where any record with a date stamp before the date and within 30 days of the date in my first table, is appended. Where there are no such records in my second table, I want to include the date from my first table, but with null values.
Project ID: 26906470

About the project

17 proposals
Remote project
Active 4 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
17 freelancers are bidding on average $11 USD/hour for this job
User Avatar
Hi It will be a left join with second table. I have good SQL query writing skills using Postgres. I will need either remote access to your desktop or you can provide the table structure of both the tables. Looking forward to your reply.
$9 USD in 2 days
5.0 (4 reviews)
4.7
4.7
User Avatar
Hi, hope you are fine. I have gone through your job description. You want to join two tables where you want only those records which are before the date and within 30 days of the date of first table. I'm SQL expert with more than 4 years of experience. I will complete the solution within few hours. Let's connect to discuss. Thanks
$8 USD in 40 days
5.0 (1 review)
3.3
3.3
User Avatar
Hello, I have 10+ year of experience in PostgreSQL. I could help you in writing the given SQL. Please initiate chat to discuss in detail. Regards, Hima.
$20 USD in 10 days
5.0 (2 reviews)
3.4
3.4
User Avatar
Hello, how are you? I hope you are well, I am very interested in your project, I have good experience with POSTGRESQL, I have made complex and simple queries, subqueries, databases with many index tables, triggers, views, etc., I can help you, write me I always answer the messages.
$9 USD in 40 days
4.6 (5 reviews)
3.3
3.3
User Avatar
I can help you. Ping me to get your right result and faster. I have an experience of 10 years in Database and having 4 years in Postgres DB.
$12 USD in 40 days
5.0 (1 review)
2.3
2.3
User Avatar
Hi there, It would be best if you show me up and i would bring out the optimal possible solution Regards Gourav
$12 USD in 1 day
5.0 (2 reviews)
2.3
2.3
User Avatar
I have more than 13 years of IT experience with various database technologies. Working Knowledege of Postgres,MS-Sql,Oracle Databases. Expertise in postgres developing skill , proficient in T-SQL writing stored procedures, triggers and functions. Worked in build complex query. Good written and client interaction skills at all management level. Energetic self-starter and can learn new technology in short time. Tuning query performance and recommending better way to optimize SQL queries and pl-pgsql/T SQL programs Migration experience from Oracle to Postgres, Postgres to MS-SQL. Performed migration till 5 TB of Databases. Having Developing/DBA experience of postgres database size more than 10 TB. less
$12 USD in 40 days
4.0 (1 review)
2.3
2.3
User Avatar
Hi Client, I have experience writing complex join queries with conditional clause. Please reach out on chat we can discuss and close this. Thanks. Regards, Vinod
$10 USD in 40 days
5.0 (5 reviews)
1.5
1.5
User Avatar
Hi There, My name is Abdul Rehman. I have much experience to design and develop the database in different kinds of platforms such as MS SQL SERVER, ORACLE, MY SQL, POSTGRE SQL. My main work area to work on databases, Queries , functions and stored procedures. I read your requirements don't worry i will join the tables. Kindly inbox me for further queries. Thanks
$8 USD in 40 days
5.0 (1 review)
1.6
1.6
User Avatar
I have been in this field for more than 7 years. i have experience in C#,php,Perl,wordpress,Html,postgress ,Ubuntu,Crontab,Web Services, Rest Api, Zend ,YIi,Mysql. Relevant Skills and Experience so i am right candidate for your project because i have experience in C#,Perl,php,node.js,Ubuntu,Crontab,Crypto currency,Wordpress,Ebay,Amazon,Instagram,Mysql,Sqllite,Mongo Db, Soap Api projects.
$12 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey there. I could help you with that. Just send me the sql files. I'll get it done. Please contact me if you interested. Thanks
$10 USD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hey! If you already have an the access to the database, just give it to me and i will create the query. Or, if you have the sql files, send me so i can recreate your database, thanks. It's quite an easy task i guess! Thanks, Marco
$8 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Don't pay me if you're not satisfied Relevant Skills and Experience I have experience as programmer more than 10 year
$9 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would like to be paid weekly if not daily. Depending on the work and task completion, it would be much clearer to understand the value generation.
$9 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am currently working in PostgreSQL and SQL every day writing some complex query related to joining user-defined function I read the requirements I am ready to work on that
$8 USD in 60 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ROMANIA
Băilești, Romania
5.0
1
Member since Mar 8, 2020

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.