sam2929
asked on
functional spec
empld code amount effdt
21 123 21 jan-10-2011
21 123 10 jan-12-2018
21 231 10 feb 12-2019
I have sql as below
select sum(amount),
max(effdt)
from table aa
group by
emplid
code
result are
empld code amount effdt
21 123 31 jan-12-2018
21 231 10 jan-12-2019
I need to write functional spec i have put below words please let me know if that make sense for non technical person.
Return sum of amount associated with emplid and code
and
Return max of effective date associated with emplid and code
21 123 21 jan-10-2011
21 123 10 jan-12-2018
21 231 10 feb 12-2019
I have sql as below
select sum(amount),
max(effdt)
from table aa
group by
emplid
code
result are
empld code amount effdt
21 123 31 jan-12-2018
21 231 10 jan-12-2019
I need to write functional spec i have put below words please let me know if that make sense for non technical person.
Return sum of amount associated with emplid and code
and
Return max of effective date associated with emplid and code
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.