Moving day wise window, sum calculation for different days
€2-6 EUR / ชั่วโมง
I need some help in my sql stuck with some project where i need to make a sliding ,moving window of sum of different amounts of money(threshold set for all days) in last 1,20, 40 and 150 days. The one with 40 days is slightly on a different filter. This window checks if transaction is beyond a certain amount in these days then some documents are needed. All data is arranged in tables.
Second query relates to first in a way that if highlighted in first case then it needs to be checked if documents were provided in next 10 days.
I have done the first query using sub queries but i am stuck in last part of first one where i need to use some more conditions for 40 days and cannot include it in the same set of sub query.
Do let me know i need urgent help.Thanks.
หมายเลขโปรเจค: #26809488
เกี่ยวกับโปรเจกต์
freelancer freelancer 5 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ €7/ชั่วโมง
Hello, I am SQL expert and good in Mysqlm, MSsql, MariaDB... for DDL, DML queries, procedures, DB design and management.. SO I can fix your issue easily and quickly. Please contact to me to have fast and good result. T เพิ่มเติม
I have read your project description in detail and it seems just like that you posted this for me. I have 10 years of IT programming. My Technical background Database/Datawarehouse - SQL Server, Oracle, MySQL, Postgre เพิ่มเติม
i am expert in SQL just because i am student of IT i have done my work with 100% Satisfaction i am waiting.....
Hi, I am proficient in Sql and certified in SQL Querying 70-461. If you need urgent help I can do it. Please contact me for discussion about your project.