Need help with the sql query

Ukončen Zveřejněno před 5 lety K zaplacení v momentě doručení
Ukončen K zaplacení v momentě doručení

Need help with the sql query for the following:

Need to add a subquery to the Supplier table script - select supplier ID (d1_fornece) and invoice date (d1_emissao) from table SD1330, join to SF1330 (as in the Invoice query) and then from that table to SE4330 where payment terms are in the field E4_DESCRI. Select only the most recent record, by invoice date, for each supplier. Join this back to SA2330 on supplier ID and then change Payment Terms from NULL to E4_DESCRI in the subquery.

Please help me on this one.

Thanks,

MMB

Hadoop Hive Linux MySQL SQL

Identifikační číslo projektu: #18686945

O projektu

30 nabídek Projekt na dálku Aktivní před 5 lety

30 Freelnceři na tento projekt zveřejňují nabídky v průměru $22

deepakgoyal92

I am oracle certified SQL developer. I can do this very well. Lets talk and solve this problem. I am waiting for your response

$25 USD za 20 dní
(24 Recenzí)
4.7
Proolancer

I m a database administrator with 8 years of experience in this industry. I read your project details and attached files and I understood your needs ,I can do what you want in the deadline just contact me and we can d Další

$10 USD za 3 dní
(6 Recenzí)
4.0
catstevens2009

Hi there! Have done this type of work before and am a SQL expert. Please feel free to message me with additional information or with questions if any, thanks!

$15 USD za 1 den
(10 Recenzí)
4.2
sreenivas2903

hi i am expertise in sql server and sql querying please let me knowif you are intersted , ping me for more details

$30 USD za 1 den
(10 Recenzí)
4.1
andersonstinger

Hello dear, I see that you are needing help with a SQL query, I am SQL expert and I can help you with that. Contact me and I will solve it quickly.

$25 USD za 1 den
(4 Recenzí)
2.3
jeanfdehaerne

Hey there, Longtime MySQL dev here, would be happy to help. Could you send me a database schema, and then we can figure things from there? Being able to see your DB structure would really help putting your proble Další

$30 USD za 1 den
(1 recenze)
2.1
vasilyalevizos

I read your description carefully and I am very confident that I can complete the task. Please don't hesitate to chat with me to discuss further details about the script. Have a nice day. Best regards, Vasileios A.

$20 USD za 3 dní
(2 Recenzí)
2.0
nidhi1509

I have good experience working with Sql queries for over 6 years. I have seen your project requirements and I am sure I would be able to complete this project as required in the given time frame.

$25 USD za 1 den
(1 recenze)
1.2
Mdware

HI I can easily and very quickly do this for you, in just a few hours. I have 15 years experience and have written thousands of complex Sql server Stored procedures, Triggers, Functions, tables sing T-SQL 2016/2014/2 Další

$25 USD za 1 den
(1 recenze)
1.0
Satheeshtetro

Hi, Hope you are doing good. I have gone through the full project description carefully. As 7+ years experienced SQL server developer, I can finish this project for 2 days at free of cost since I am new to the freela Další

$10 USD za 2 dní
(1 recenze)
0.4
Farhan81o

hello i will be the good choice for this task having 3year experience in web development you may visit portfolio looking forward to get connected

$20 USD za 1 den
(0 Recenzí)
0.0
rajavattikonda

Expert in SQL,Plsql

$25 USD za 1 den
(0 Recenzí)
0.0
Komalkritika

I am very good in sql writing and can help you with this requirement

$20 USD za 1 den
(0 Recenzí)
0.0
RaghureddyMSBI

I am working professional with 3 + years of experience database concepts and SQL database administration

$25 USD za 1 den
(0 Recenzí)
0.0
livire

Hello Sir, I can do this query FREE of cost for you. Just rate me 5 stars if you like my work. Regards, Faisal Saeed.

$25 USD za 1 den
(0 Recenzí)
0.0
jayantavkumar

Call me on my cell. It will not take more than 10 mins to be done. (Nine Nine eight five nine two seven six seven three).

$20 USD za 1 den
(0 Recenzí)
0.0
muradafghan

Hello sir, I use to work with sql server databases with more then 200 tables. Let me do this task with no delay .

$25 USD za 1 den
(0 Recenzí)
0.0
ZOUK13

Hello , I came across your project and would be a pleasure to offer my help on this task. Per the project description, the final target is to update the Supplier information with the most recent payment type. If Další

$10 USD za 1 den
(0 Recenzí)
0.0
ijaswanth

I can give you the most efficient query. You will not have any performance issue. I am very familiar with the technologies you are looking for.

$30 USD za 2 dní
(0 Recenzí)
0.0
misaelferrer

I have more 5 year of experience making complex SQL query in PostgreSQL, MySQL, Oracle, Vertica and SQL Server Databases, i can help you. Regards

$20 USD za 1 den
(0 Recenzí)
0.0