[firebird-support] How to get different Maximum Data for every single date in the table?

Hi All, As per the attache files or below specified table DDL, DML and SQL, I need to get below details: Get Order_ID, Order_Date, Salesman_ID for different Salesmen :1. Who sold maximum Copy for a day2. Who sold maximum amount of book for a day3. Who got maximum order for a day As per below SQL

Re: [firebird-support] How to get different Maximum Data for every single date in the table?

Den 17.07.2017 12:30, skrev Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]: > Hi All, > As per the attache files or below specified table DDL, DML and SQL, I need to > get below details: > Get Order_ID, Order_Date, Salesman_ID for different Salesmen :1. Who sold > maximum Copy for a da

Re: [firebird-support] How to get different Maximum Data for every single date in the table?

Hi SET, First of all Thank You for the SQL. Let me go through. I am ready if you get enough time to look into good solution for this, and I would wait for you. This is also different type of SQL I am seeing and feeling happy to learn valuable things from it. Thank You So much SET. But I would

Re: [firebird-support] How to get different Maximum Data for every single date in the table?

Hi again, Vishal! Here's a different query that will reasonably often give you what you want: with CopyToTals( Order_ID, Order_Date, Salesman_ID, Copy_Sold, ToTal_Amount ) as ( select Order_ID, Order_Date, Salesman_ID, Sum( Copy_Sold ), Sum( ToTal_Amount ) from Ordered_B

Re: [firebird-support] How to get different Maximum Data for every single date in the table?

YOU ARE MY JUST A SUPERSTAR. JUST RAN THE SQL AND MESSAGING YOU. LET ME GO THROUGH YOUR MAIL COMPLETELY... YOU AGAIN PROVED YOU ARE THE MASTER-BLASTER SET... LOVE YOU A LOT...WILL BACK TO YOU SONN THANK YOUUU On Wednesday, 26 July 2017 7:05 AM, "setysva