Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to get sum(value) from this table for each Dept on first minimum date for the year of 2016.
Ex:
Dept Date Value Year
CSE 28-Dec-2015 50 2015
CSE 1-jan-2016 200 2016
CSE 3-jan-2016 100 2016
EEE 1-jan-2016 150 2016
EEE 3-jan-2016 100 2016
ECE 5-jan-2016 300 2016
ECE 7-jan-2016 400 2016
Result:
CSE 200
EEE 150
ECE 300
No problem at all