Link to home
Start Free TrialLog in
Avatar of sam2929
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
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial