SQL Queries Specialist
₹400-750 INR / Stunde
I am urgently in need of a SQL expert proficient in MySQL. I require assistance with writing data definition queries.
Work Expectations:
- Writing proficient data definition SQL queries.
- Extensive knowledge of MySQL.
Below is my query. Need to modify the query and get the count as 0 for the column srce_syst_paty_i
SELECT COUNT(*)
FROM (
SELECT
CASE
WHEN PATY_IDNN_BK LIKE '%SAP%' THEN SUBSTR(PATY_IDNN_BK, INSTR(PATY_IDNN_BK, '+') + 1)
WHEN PATY_IDNN_BK LIKE '%BCB%' THEN SUBSTRING_INDEX(PATY_IDNN_BK, '~', -1)
END AS srce_syst_paty_i,
*
FROM dev_enr.cpln_svrq_paty_detl
WHERE day = '02' AND month = '06' AND year = 2023
) src
INNER JOIN (
SELECT *
FROM dev_oal.bv_fcf_svrq_cpln_paty
WHERE day = 02 AND month = 06 AND year = 2023
) trgt ON src.cpln_svrq_idnn_bk = trgt.svrq_idnn_bk
AND src.snap_d = trgt.snap_d
AND src.paty_idnn_bk = trgt.paty_idnn_bk
AND src.paty_seqn_n = trgt.recd_chng_idnn_seqn_n
Where nvl(src.srce_syst_paty_i, ' ') <> nvl(trgt.srce_syst_paty_i, ' ')
Projekt-ID: #37843598
Über das Projekt
33 Freelancer bieten im Durchschnitt ₹726/Stunde für diesen Job
Hi There, I have reviewed your query and we can achieve the result. Send me message for further conversation. Regards
Hello, I can start immediately. I have 13+ years of experience and I ensure you I can complete the project within budget and timeline. I'm not just a developer; I'm your dedicated partner. I'm committed to working with Mehr
SQL EXPERTS! We are working on sql since last 11 years. We could do it. Could we discuss in details over chat now? Best Regards Techwelfare
Hello, i am experienced SQL developer with extensive knowledge of MySql. i can help with your requirement. Let's connect over chat and i can start this work right away. Thanks,
Hi, I specialize in SQL queries and MySQL. I can modify your query to ensure the count for the column srce_syst_paty_i is 0. Let's start optimizing your SQL query. Let's start.
Hi I am santosh , having 10+ Years of experience of work in GLOBAL ERP Oracle forms,SQL, pl/sql,MSSQL,MYSQL Apex, OAF, Workflow, EBS R12 and Oracle BI Publisher Report as well we provide fully customized ERP software Mehr
I have 20 years of full time experience in database design, development and query optimizations in Oracle, SQL Server and MySQL. I can work on solving MySQL query issue you have posted in efficient way as per your requ Mehr
As an experienced SQL expert with a deep proficiency in MySQL, I have consistently showcased my ability to handle complex data sets and write proficient data definition queries. Specifically, I leverage infinite possib Mehr
Certainly, I can help with your MySQL query. To achieve the requirement of getting the count as 0 for the column srce_syst_paty_i, I have modified the query. Below is the adjusted query along with an explanation
Has good experience in working on various sql queries. Optimised several queries and brought good performance pf the applications.I would like to work along with you to provide my best contribution in order to complete Mehr
Hello, I'm Gia from Indonesia. Can i get a sampe data/records/table for source a query. I can start immediately. Thanks, Gia.
As a highly experienced SQL expert, I have extensive knowledge of using various database management systems including MySQL, which is vital as per your project requirements. I have been deeply involved in writing extre Mehr
Hi , This is Jabeen an expert in SQL database developer. I have 6+ years of experience in SQL, am good at writing queries I hope my experience will help you to reach out. Do let me know if you are interested Thank you
Hi. Good Morning, I have ETL and reporting experience, all of my working related SQL and reporting, I can you to solve the problem, but I need more info regarding the current, what are trying to get? Please call ping Mehr
