Need help with the sql query

Κλειστό Αναρτήθηκε Πριν 5 χρόνια Πληρώθηκε κατά την παράδοση
Κλειστό Πληρώθηκε κατά την παράδοση

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

Ταυτότητα Εργασίας: #18686945

Σχετικά με την εργασία

30 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 5 χρόνια

30 freelancers κάνουν προσφορές κατά μέσο όρο $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 σε 20 μέρες
(24 Αξιολογήσεις)
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 Περισσότερα

$10 USD σε 3 μέρες
(6 Αξιολογήσεις)
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 σε 1 μέρα
(10 Αξιολογήσεις)
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 σε 1 μέρα
(10 Αξιολογήσεις)
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 σε 1 μέρα
(4 Αξιολογήσεις)
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 Περισσότερα

$30 USD σε 1 μέρα
(1 Κριτική)
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 σε 3 μέρες
(2 Αξιολογήσεις)
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 σε 1 μέρα
(1 Κριτική)
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 Περισσότερα

$25 USD σε 1 μέρα
(1 Κριτική)
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 Περισσότερα

$10 USD σε 2 μέρες
(1 Κριτική)
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 σε 1 μέρα
(0 Αξιολογήσεις)
0.0
rajavattikonda

Expert in SQL,Plsql

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
Komalkritika

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

$20 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
RaghureddyMSBI

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

$25 USD σε 1 μέρα
(0 Αξιολογήσεις)
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 σε 1 μέρα
(0 Αξιολογήσεις)
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 σε 1 μέρα
(0 Αξιολογήσεις)
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 σε 1 μέρα
(0 Αξιολογήσεις)
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 Περισσότερα

$10 USD σε 1 μέρα
(0 Αξιολογήσεις)
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 σε 2 μέρες
(0 Αξιολογήσεις)
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 σε 1 μέρα
(0 Αξιολογήσεις)
0.0