Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Want to find the max date on the basis of type Del and Serial no.
Like to show only max Del Data .
Input:
Qty | Type | Date | Serial_no | Dealer |
---|---|---|---|---|
1 | Del | 13/05/2017 | A1 | D01 |
1 | Delrt | 15/05/2017 | A1 | D01 |
1 | Del | 12/08/2017 | A2 | D02 |
1 | Del | 13/08/2017 | A3 | D03 |
1 | Delrt | 14/05/2017 | A3 | D03 |
1 | Del | 15/08/2017 | A3 | D04 |
1 | Del | 16/08/2017 | A4 | D05 |
1 | Delrt | 16/08/2017 | A4 | D05 |
1 | Del | 17/08/2017 | A4 | D05 |
1 | Del | 18/08/2017 | A5 | D06 |
1 | Delrt | 19/08/2017 | A5 | D06 |
1 | Del | 19/08/2017 | A5 | D06 |
output
Qty | Type | Date | Serial_no | Dealer |
---|---|---|---|---|
1 | Del | 12/08/2017 | A2 | D02 |
1 | Del | 15/08/2017 | A3 | D03 |
1 | Del | 17/08/2017 | A4 | D05 |
1 | Del | 19/08/2017 | A5 | D06 |
Can anyone provide the solution.
Thanks in Advance..
thanku so much for the desired answer.