Suljettu

Postgres Join help required

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.

Taidot: PostgreSQL, SQL

Näytä lisää: postgresql join multiple tables, postgres join types, postgres multiple joins, postgres join on multiple conditions, postgres natural join, postgres cross join, postgres inner join, postgres join using, help required adword, help required making project plan 250 seaters callcentre, visual basic excel help replacing values, spss help required project, vtiger help required field, seo help required, fortran help required, assignment help required, help required project, research help required, essay help required, words help required

Tietoa työnantajasta:
( 1 arvostelu ) Băilești, Romania

Projektin tunnus: #26906470

17 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön

bestflancer

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. Lookin Lisää

$9 USD / tunti
(4 arvostelua)
4.7
TEKSCENT

I have around 10 years of professional experience in sql development and worked in more than 200 [login to view URL] discuss your requirements.

$17 USD / tunti
(9 arvostelua)
3.9
ahaseeb7838

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 wit Lisää

$8 USD / tunti
(1 arvostelu)
3.3
himamahi09

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 / tunti
(2 arvostelua)
3.4
Darwin21015

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, vie Lisää

$9 USD / tunti
(5 arvostelua)
3.3
gouravkumargupta

Hi there, It would be best if you show me up and i would bring out the optimal possible solution Regards Gourav

$12 USD / tunti
(2 arvostelua)
2.3
sankargan88

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 / tunti
(1 arvostelu)
2.3
amindharmesh

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 procedu Lisää

$12 USD / tunti
(1 arvostelu)
2.3
vinodkumar7594

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 / tunti
(5 arvostelua)
1.5
abdulrehman578

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, Lisää

$8 USD / tunti
(1 arvostelu)
1.6
yogasefianto

Don't pay me if you're not satisfied Relevant Skills and Experience I have experience as programmer more than 10 year

$9 USD / tunti
(0 arvostelua)
0.0
marcos979797

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! Lisää

$8 USD / tunti
(0 arvostelua)
0.0
panhavoan

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 / tunti
(0 arvostelua)
0.0
rabhardwaj

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 candida Lisää

$12 USD / tunti
(0 arvostelua)
0.0
princebillyGK

I can ensure your satisfaction. I can write complex and powerful queries in postgreSQL. View my 5 star SQL badge in Hacker rank [login to view URL]

$11 USD / tunti
(1 arvostelu)
0.0
Oni44cfc

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 / tunti
(0 arvostelua)
0.0
Vickys2

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 / tunti
(0 arvostelua)
0.0